Using the right TnsNames.ora ?

[Hans Erik Busk]

Just a small problem.
(Version 3.3 Delphi5)
When using the property editor for OracleSession.LogonDataBase the names shown are taken from D:\ORANT\NET80\ADMIN\TnsNames.Ora
instead of
D:\oracle\ora81\network\TnsNames.Ora

In the registry I have defined the NET80 parameter to the latter location, and when running the program names are taken from the correct TnsNames file.
Where does the designer find the path for TnsNames.Ora?

------------------
busk

 

[Marco Kalter]

By the looks of it you have multiple oracle_home's: one at d:\orant and one at d:\oracle\ora81. Direct Oracle Access will use the primary oacle_home, as defined through the Oracle Home Selector. Could this explain the problem?

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

 

[Hans Erik Busk]

Yes, sure helped. The strange thing is that when the Delphi program is running it finds the right TNSNAMES file.
According to Oracle docs the correct registry value should be in TNS_ADMIN, where the path for configuration files should override NET80 values. But not even Oracle developer 6.0 seems to follow this!