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