Cant connect ODAC to client Oracle 64x

[rcedano]

Hi,

Recently migrate to XE5, I have some problems toconnect to ORACLE 11g (x64 bits), in my developer have the component s: TOraSession, TOraQuery and TOraProvider, and the configuration of my project are the next:

SO: Windows 7 64 bits
Oracle DB : Oracle 11g;
Oracle Client 64 bits.
Delphi XE5 target 64Bit.
ODAC v.19 for XE5

The main problem is with the component TOraSession in the parameter “HOME”, I can’t load my client of Oracle in 64 bits(OraClient_Home1), anyone know if I can connect to the client in 64-bit and how connect through client?

Regards

[AlexP]

Hello,

Delphi is a 32-bit application, therefore, when running a project from Delphi, you can use only 32-bit libraries; if you run your application from an *.Exe file, ODAC will correctly load the 64-bit oci.dll. If you are going to connect to Oracle in design-time from Delphi, you should also install a 32-bit Oracle client.

[rcedano]

Hi AlexP,

Thank You for help me to resolve the issue, I changed the target to 64 bits and compiled with a client 32 bits, when I installed the application in the server with client 64 bit this is working good, now I have problems with the midas.dll, do you know something above this issue??

Regards

[AlexP]

Please describe in more details the problems occurred when using midas.dll.