Print Thread
How to select ORACLE_HOME for DOA
#32868 12/01/08 01:18 PM
Joined: Feb 2007
Posts: 37
Denmark
B
Busk Offline OP
Member
OP Offline
Member
B
Joined: Feb 2007
Posts: 37
Denmark
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.

Re: How to select ORACLE_HOME for DOA
Busk #32874 12/02/08 11:11 AM
Joined: Aug 1999
Posts: 22,226
Member
Offline
Member
Joined: Aug 1999
Posts: 22,226
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.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.028s Queries: 14 (0.007s) Memory: 2.5006 MB (Peak: 3.0423 MB) Data Comp: Off Server Time: 2024-06-02 05:46:59 UTC
Valid HTML 5 and Valid CSS