I have a need to get the sid, host string, and the port from the tnsnames.ora for the tnsnames entry the user specifies when logging in to an app I wrote using DOA. The problem is there can be (and frequently are) more than one Oracle client installed on a given machine. So, how can I find the exact tnsnames.ora used by my DOA app?

Thanks,
Eldon

The location of the tnsnames.ora file that Direct Oracle Access has determined is not accessible from within your application. If you have the source files, then it's easily made available, just search for 'tnsnames.ora' in OracleCI.pas. We will add a public variable for this in 3.4.


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