How to select ORACLE_HOME for DOA

[Busk]

I have problems, with DOA probably related to multiple Oracle homes.
So far I have been using OCI: version 9.2, because of integration with Forms 6i (client/server).

After installing some Oracle tools version 11, my delphi programs are unabe to connect to the database - no errormessages, just an ok-dialogbox with "delphi7".
Oracle Forms can still connect as usual.

I have ensured that the Windows path points to the old oci.dll directory (orant\bin)as the first item.

In PL/SQL I had the same problem, but selecting the Oracle10 home and corresponding oci solves the problem for that product.

Now the question is: how can I make a similar selction for DOA?

I know the the Oranet version is way past its maintenance date, but I still have to use it for client/server Forms.

 

[Marco Kalter]

By default, Direct Oracle Access uses the primary Oracle Home, this is the home that is listed first in the Path environment variable.

If you need to, you can determine all available Oracle homes with the OracleHomeList function (located in the OracleCI unit). You can select a specific home by setting the OracleHomeName variable. Note that the OracleHomeName must be set before making a connection.