Page 1 of 1
Cannot load OCI DLL. Oracle 11 and ODAC 8.1
Posted: Tue 07 Feb 2012 08:10
by emod
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.
Posted: Tue 07 Feb 2012 09:05
by AlexP
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).
Posted: Tue 07 Feb 2012 09:32
by emod
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
Posted: Tue 07 Feb 2012 09:52
by AlexP
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.