How DOA connect to Oracle 8?

[rigo.massimo]

How does DOA do to connect to Oracle 8i, which does the keys and strings of system registry read?
There is a different method to read from the version 3.4.2 to 3.4.3?
Thank, Max.

 

[Marco Kalter]

Both 3.4.2 and 3.4.3 first determine the primary oracle home by reading:
hkey_local_machine\software\oracle\all_homes

The home directory that is listed first in the PATH is the primary oracle home. From this directory, the oci.dll library is loaded, which is used to connect to the database.

 

[rigo.massimo]

I send you this question because we had a problem with connect to Oracle 8i Lite (4.0.1) and Oracle 8i Server (8.1.6) in the same machine and in the same application.
We had use an "exe" to connect to oracle 8i Server and a "dll" to connect to OraLite. The problem was the oci.dll's 8.1.5 is diffent than oci.dll's OraLite.
To resolve this problem we have modificated a dll (editing a compiled code) and change the voice "ORACLE_HOME" in "ORA8iL_HOME", which in a new voice in the registry (hkey_local_machione\software\oracle)the point to a directory ("d:\oracle\ora8iLite") where there is a client of OraLite (with your oci.dll).
With this solution the program run, but is sensitive of change version of DOA.
This solution si not very smart, but is correct?The optimus is to have a documentation for change it in delphi code.
Thanks for all, Massimo.

 

[Marco Kalter]

I'm not sure if I understand what you have done, but to force a specific oracle home or OCI DLL, you can use the variables mentioned in the OracleCI paragraph in the User's Guide and help file.

------------------
Marco Kalter
Allround Automations