Oracle 11g - Could not locate OCI dll

[Norbert]

I installed ODAC1110720 on a brand new machine winserver 2003.

I get an Initialization error
Could not locate OCI dll.

The path variable is set correctly but I notices that the oracle installer copies the oci.dll into the main directory "C:\app\Administrator\product\11.1.0\client_1" and not in the bin directory C:\app\Administrator\product\11.1.0\client_1\bin. Actually copying the oci.dll into the bin directory solves the problem but is not an option for me.

I'm using 4.0.7.1 any Idea how to solve my problem without copying the dll or to use an other installer ?

Thanks Norbert

 

[Marco Kalter]

The current 4.1 version will find the DLL in the root directory of the Oracle Home. In 4.0 you can explicitly set the OCIDLL variable to 'C:\app\Administrator\product\11.1.0\client_1\oci.dll' to make this work.

You can also set it from the command-line:

YourApp.exe ocidll=C:\app\Administrator\product\11.1.0\client_1\oci.dll

 

[Norbert]

Thanks,

I recompiled with Version 4.1 and it solved my problem.

Thanks again for the fast reply.

Norbert