DOA setup for new 10g Instant Client

[AsherAtkinson]

What configuration is required to get my Delphi 7 development W2K machine setup so that I can use DOA 4.0.5 with Oracle's new 10g "instant client"?

I have dropped the instant client files into c:\oracle and I can connect with SQLPlus. My path includes c:\oracle and my environment has the settings TNS_ADMIN=c:\oracle and ORACLE_HOME=c:\oracle. My tnsname.ora and sqlnet.ora are located in c:\oracle\network\admin. Yet when I check the DOA info from within the Delphi IDE (Oracle|Info...) I see OCI.dll is not initialized. If I run an application that simply tries to make a connection using TOracleSession I don't items from my tnsnames.ora in the database dropdown list.

Where is DOA looking for tnsnames.ora? Is it expecting registry settings or additional/different environment settings? Please let me know how my environment should be configured for use with the 10g "instant client".

Thanks in advance.

- Asher Atkinson

 

[Marco Kalter]

We will support the Oracle 10g Instant Client in the next patch release. You can still work with it though.

The TNS_ADMIN environment variable must point to c:\oracle\network\admin. This way Direct Oracle Access will be able to pick up your tnsnames.ora file.

Furthermore you can specify the OCI Library on the command line of your application. For example:

myapp.exe ocidll=c:\oracle\10g\bin\oci.dll

In the Delphi IDE you can set the OCIDLL through the Oracle > Preferences menu.