Error with two clints installed

[Cory Jay]

I have a Windows 7 Pro 64-bit system with MS Access 2010 installed.

I initially installed Oracle client 10.2.0 to access the 10g database using Oracle SQL Developer 2.1.1.64. This works fine.

In order to get MS Access to be able to connect to Oracle via ODBC, I needed to install Oracle client 11.2.0. This works fine also. Both Installs work fine without setting ORACLE_HOME.

I then installed Embarcadero RAD Studio XE and DOA 4.1.2.0. When I look in the info under the Oracle menu item in Delphi, the message box says OCI: not initialized.

When I change ORACLE_HOME to either of the two client paths, and I place a TOracleSession on a form, I can select the Oracle instance from the drop down and enter my credentials but, when I click on the "Connected" check box, an error message box pops up in the middle of the screen with no identifying information.

I click on the "Details..." button and the first line in the box reads '[16665CB6]{doa41dXE.bpl} Oracle.EOracleError + $1196'

Any help?

Cory

 

[Cory Jay]

I modified the "PATH" environment variable so that the 10x client path is before the 11x client path. I now get OCI initialized but I still get the same error.

I changed the ORACLE_HOME to the 10x path as well.

Cory

 

[Marco Kalter]

You will need to install a 32 Bit Oracle11g client on Windows 7 x64. The Oracle10g client in not compatible with Windows 7 x64.

 

[Cory Jay]

That took care of it.

Thanks,

Cory