Page 1 of 1
Multiple Oracle Home 7 and 10 never find Oracle 7
Posted: Mon 15 Dec 2008 11:32
by sandrine
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.
Posted: Tue 16 Dec 2008 08:51
by Plash
Probably the Oracle 10 installation has corrupted registry settings for the Oracle 7 client. So you cannot use both clients on the same machine.
Posted: Tue 16 Dec 2008 09:29
by sandrine
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 ?
Posted: Wed 17 Dec 2008 09:46
by Plash
We'll add support for detecting Oracle 7.3 home list in the next ODAC build.
Posted: Fri 16 Jan 2009 12:00
by sandrine
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.
Posted: Mon 19 Jan 2009 08:44
by Plash
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.