Re: NT4.0 client SQL*Net problem

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1998/11/03
Message-ID: <71m8bm$mt7$1@hermes.is.co.za>#1/1

Steve Culy wrote in message <363E6A70.470DD464_at_boulder.vni.com>...

>(HPUX) from Oracle 7.1.6 to 7.3.2. When our ODBC
>application runs on the client, we get the following error:
>
>ORA-12154: TNS:could not resolve service name.
>
>I know that this error usually means that I have botched
>the SQL*Net setup somehow. <lots of bug hunting snipped>

Holmes told Watson if you eliminated all possibilities, whatever remains, no matter how unlikely, must be the answer. (or something like that)

My guess is that the problem must be inside the client that uses the ODBC driver. For some reason it's using a TNS alias that is no longer valid. Maybe it should use the .WORLD suffix - or maybe it should not. Or maybe there's a case sensitivity problem.

That will 10 pounds Sir, you can pay my houselady on the way out. <lighting up my pipe> ;-)

regards,
Billy Received on Tue Nov 03 1998 - 00:00:00 CST