On my Windows XP Pro desktop, I have been using a DSN configured using Oracle ODBC Driver 8.00.58.00 to connect to a 9i database for a few years. Suddenly, I started getting "Ora-12154 TNS:could not resolve service name". In fact, all of my Oracle DSN's now fail, same error. Some use Oracle driver 9.02.00.00, so the issue is not any specific driver. I have multiple Oracle homes on my machine and each has the same tnsnames.ora and sqlnet.ora files; none of these have been changed, and no Oracle software has been added to my machine. SQL*Plus and other third-party products can all connect to the databases that odbc fails to connect.
The 12154 error is very specific and I know this sounds like straight-forward fix, but I cannot get around the error.
Looking at the following excerpt of an odbc trace, it appears that the problem occurs in the call to SQLDriverConnectW; but I cannot determine where the driver is looking for alias resolution.
Anyone know how to determine where the driver is looking? Perhaps other advice?
Here's the ODBC trace:
Request Managem 14b8-1538 ENTER SQLSetConnectAttrW
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>