Page 1 of 1

Can't find OCI.DLL

Posted: Tue 09 Jun 2009 12:42
by jjeffman
Hello.

I am using ODAC 6.70.0.41 on C++Builder 6 Professional Edition.
The application I have made using ODAC works perfectly in the
develop environment. When I have tried it on the end user environment
I have got the error "Can't find OCI.DLL".

I have ran the Windows Regedit application to check if there was an
Oracle Client installation. The Oracle registry keys were all in the
Windows Registry. The file path shown in the Registry actually exists
and the OCI.DLL is placed where it should be.

I can connect using Direct mode.

Why am I getting that error ? Do you have any clue ?

The Oracle Client installation type is a minimum one I guess. They
do not install any Oracle client applications like SQL*Plus and others
for security matters.

Thanks.

Posted: Tue 09 Jun 2009 12:48
by Plash
Please check that the path to OCI.dll is present in the PATH environment variable.

Posted: Tue 09 Jun 2009 13:08
by jjeffman
It is present and it is the first path in the windows PATH variable.

Posted: Fri 12 Jun 2009 06:48
by Plash
Maybe the installation of Oracle client is corrupted. Please try to make a test project that loads OCI.dll using the LoadLibrary function. Check if you can load OCI.dll in the test project.

If the DLL cannot be loaded, maybe reinstalling the Oracle client will resolve the problem.

Posted: Sat 13 Jun 2009 18:13
by shalamberidze
Check permission on oracle_HOME directory. Maybe you test your app in administrator mode but work with user privileges