Multiple Oracle Home 7 and 10 never find Oracle 7

sandrine · Post by **sandrine** » Mon 15 Dec 2008 11:32

Odac 6.70.0.43
Delphi 7
Client 7 + Client 10 on the client machine

How can I connect to an Oracle 7 server using Oracle 7 client when both Oracle7 and Oracle10 clients are installed on the client machine ?

I tried to specify HomeName property of the TOraSession but it doesn't work because it only finds Oracle10 homes.

Plash · Post by **Plash** » Tue 16 Dec 2008 08:51

Probably the Oracle 10 installation has corrupted registry settings for the Oracle 7 client. So you cannot use both clients on the same machine.

sandrine · Post by **sandrine** » Tue 16 Dec 2008 09:29

The Oracle 10 installation has not corrupted registry settings. If I rename the Oracle10 directory, ODAC is working fine provided I don't specify a homename.

The problem is in DetectOci procedure in // get library name from homes part.
When you specify Homename property, it searches OracleHomeName in OracleHomeNames array witch is an array of Oracle 10 homes (it's not populated with Oracle 7 homes) so when you have both clients, you can't use Oracle 7 client. Could you please do something for this ?

Plash · Post by **Plash** » Wed 17 Dec 2008 09:46

We'll add support for detecting Oracle 7.3 home list in the next ODAC build.

sandrine · Post by **sandrine** » Fri 16 Jan 2009 12:00

Odac 6.70.0.44

It's working fine with Oracle 7.3 and Oracle 10 clients installed on the same machine.
But when we have Oracle 7.3 client and InstantClient 10.2, it's impossible to use InstantClient 10.2 to connect to an Oracle 10 server.
With InstantClient, there is no Oracle home in the registry and it's impossible to configure Odac in order to use Instantclient instead of Oracle 7 client.

Plash · Post by **Plash** » Mon 19 Jan 2009 08:44

You can use Instant Client by setting the OCIDLL variable from the OraCall unit to the name with the path of OCI.dll from Instant Client.