Accessing Multi-TNS files

[JANTON]

At my work, we have two UNIX servers from running two different vesion (7.x and 9.x) of Oracle. They both require different versions of develper (4.5 and 6). For this reason, there are two TNS path settings.

Because of this, we set up two icons attached to two different batch files on the Windows XP Pro desktop. One sets the TNS path for Oracle 7.x and the other sets the TNS path for Oracle 9.x then runs the appropriate developer forms for the individual app.

My question is how can I externally configure a Delphi 6 application to load use the corrent TNS file based on which version of Oracle the tables reside in? Can I define the HOST as the machine IP and the PORT of 1521 or do I need to access the correct TNS.ORA file for access?

Thanks,

John A

 

[Marco Kalter]

Direct Oracle Access will use the tnsnames as configured for Oracle Net. If you set the TNS_ADMIN registry key or environment variable, your Direct Oracle Access application will automatically pick this up.