Great god give me download address, or upload your resources, to the address I use points to download, please give some instructions, novice,

CodePudding user response:

Oracle Data Access Components (ODAC) full name: Oracle Data Access Components

Advantage: because in Microsoft.net framework4 will in the System. Data. OracleClient. DLL deprecated, and in terms of access efficiency and speed, System. Data. OracleClient. DLL and Oracle. DataAccess. DLL, Microsoft does not provide Oracle has the advantages of the libraries, so I gave up using the System. For many years. OracleClient. DLL, replaced by odp.net

1. The installation of ODAC

Server: 0 racle10g, 11 g is fine



Client: oracle11g, I download the 11.2 Release 4 ODAC and Oracle Developer Tools for Visual Studio (11.2.0.3.0), oracle10g can be installed, but the lack of custom types of corresponding object, and only support vs2003 and vs2005, so I choose to use the ODAC is oracle11g version 11.2 Release 4 and Oracle Developer Tools for Visual Studio (11.2.0.3.0), download address http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html (I use ODAC 11.2 Release 2 (11.2.0.1.2) with Oracle Developer Tools for Visual Studio, download address for http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html)

2. The environment variables set

(1) the new ORACLE_HOME: ODAC installation directory (similar to app \ Administrator \ product \ 1.0 \ client_1, I here is the installation directory E: \ app \ LJP \ product \ 11.2.0 \ client_2)

(2) new LD_LIBRARY_PATH: % ORACLE_HOME %
(3) new TNS_ADMIN: % ORACLE_HOME % (here is to monitor set, should be a tnsnames. Ora directory, I set is E: \ oracle \ product \ 10.1.0 \ db_1 \ NETWORK \ ADMIN, of course, can also be configured tnsnames. Ora file copy to % ORACLE_HOME % directory)

(4) in the front of the PATH appended: % ORACLE_HOME %

CodePudding user response:

This ODAC is not those ODAC, the building Lord said ODAC is Delphi native components, can direct the Oracle server, client, without installing any Oracle software and cross-platform support for Windows/Linux/macos/ios/android

CodePudding user response:

What I need is the Delphi xe8 version, Delphi7 I have, but for Delphi xe8 not applicable,

CodePudding user response:

Yes, odac is no need to install the orcale database, or a client, you can directly connect the orcale,

CodePudding user response:

Trial version can be downloaded from here. https://www.devart.com/odac/
If you want to pro source code, and don't want to buy, only to find that what version of the