TNSnames.ora ODBC MS Access connecting problem

From: Christoph Geisse <Ch.Geisse_at_fz-juelich.de>
Date: Wed, 30 Oct 2002 17:41:37 -0000
Message-ID: <app1m4$3047$1@zam602.zam.kfa-juelich.de>

Hi,
Does anybody know how the ODBC driver resolves server names when they are described via an TNSname? Where does it look for TNSnames.ora?

I have got MS Access 97 (on WinNT) connected to Oracle8 (on AIX) via Merant/Intersolv ODBC 4.00. Everything works fine with SQLplus and the Oracle ODBC Test utility. But connecting from Access 97 refers to an old TNSnames.ora in an (not existant, old) directory. It seems that somehow the ODBC manager (or MS Access?) looks for TNSnames.ora in 'weird' directories (starting with the root of the partition?) and somewhere (?) saves the directory found.

Regards
Christoph Received on Wed Oct 30 2002 - 11:41:37 CST