Does UniDAC support the Oracle instant client?

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
cbc700
Posts: 46
Joined: Fri 03 Aug 2007 17:25

Does UniDAC support the Oracle instant client?

Post by cbc700 » Wed 01 Dec 2010 02:51

Seems if I set it up, with a tnsnames.ora and all, and set the Home option to folder the Oracle files are (this is where OCI.DLL is located), I simply get "Cannot find OCI.DLL: in C:\O\instantclient_11_2".

I've also used an empty Oracle Home and put the OCI.DLL folder on the path (and closed/reopened everything), and I still am unable to connect.

Any thoughts here? Thanks.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Wed 01 Dec 2010 09:16

Hello,

To connect to Oracle using an instance of Oracle client you should create the following registry key and values, for example:

registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\

registry values:
TNS_ADMIN=c:\OraInstantClient\network\admin
ORACLE_HOME=c:\OraInstantClient

c:\OraInstantClient <- the root path
c:\OraInstantClient\Bin <- the folder with all Oracle instant client files
c:\OraInstantClient\network\admin <- the folder with the tnsnames.ora file

it works on the 3.50.0.13 version of UniDAC.

Post Reply