Cannot load OCI DLL. Oracle 11 and ODAC 8.1

emod · Post by **emod** » Tue 07 Feb 2012 08:10

Hi, I have an application with ODAC 8.1 and Oracle 11g.

If I set the property Net False and the ConnectionString like user/pass@tnsnames dont works. Cannot load OCI DLL.

But with Net True and ConnectionString like user/pass@ip:port:sid worked fine.

With ODAC 5.80 and Oracle 10 it works fine.

Thanks.

AlexP · Post by **AlexP** » Tue 07 Feb 2012 09:05

Hello,

Please provide the following information:
- the exact version of ODAC;
- the exact version of your IDE;
- the exact version of your OS (x64 or x32);
- the exact version of your Oracle client (x64 or x32).

emod · Post by **emod** » Tue 07 Feb 2012 09:32

ODAC 8.1 (Last version)
Delphi 2006. Borland® Delphi® for Microsoft® Windows™ Version 10.0.2288.42451
Windows 7 Professional x64
Oracle Client 11gR2 x64

Thanks

AlexP · Post by **AlexP** » Tue 07 Feb 2012 09:52

Hello,

Such error can occur if a 32-bit application is used with a 64-bit client and vice versa. If you have a 32-bit application, you should use 32-bit Oracle client.
With Rad Studio XE 2 release, there is a possibility to create 64-bit applications in Delphi. ODAC supports Rad Studio XE 2 starting from the version 8.0.1, so you can create applications for bot platforms - x32 and x64, and use both x32 and x64 Oracle clients.