RE: ADO.NET and Oracle 8.1.6

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 23 Oct 2001 14:45:24 -0700
Message-ID: <F001.003B2820.20011023141534@fatcity.com>

> -----Original Message-----
> From: tday6_at_csc.com [mailto:tday6_at_csc.com]
>
> We're getting ORA-12154: TNS:could not resolve service name
>
> I've checked the TNSNAMES.ORA and SQLNET.ORA and they seem OK.
>
> WIN2K. Using the MS Oracle ODBC driver (the Oracle ODBC
> driver is a no
> go).

Are you able to connect with SQL*Plus? Do you have more than one Oracle Home on your client machine? Do you have more than one tnsnames.ora on your client machine? Are the ODBC driver and SQL*Plus using the same tnsnames.ora file? When you created your data source name in ODBC, did you put in the service name field the TNS alias? Have you tried to turn on Net8 tracing to see where the name resolution fails? Received on Tue Oct 23 2001 - 16:45:24 CDT