Page 1 of 1

Newbie question, help!!!

Posted: Tue 07 Dec 2004 02:38
by ODAC
We are using Delphi 6, accessing Oracle 8i. We have 70 client desktops on which Oracle clients are installed. We keep local copies of tnsnames.ora files on each client machine(don't ask me why as I am new to this company). This casues a pain to maintain the tnsnames.ora files. I am desperately looking for a solution that enables centralized tnsnames.ora file at a network drive where each client machine can share. What is the best approach?

I am very new to delphi and currently working as an Oracle DBA.

Oracle 8.1.7 on Windows. Using Oracle Direct Access Component 3.5 (don't know which vendor).

Posted: Wed 08 Dec 2004 07:23
by Paul
It is a question about Oracle client. You can use TNS_ADMIN registry key to
specify the path to tnsnames.ora
For more details see Oracle documentation.