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).