Re: ORA-12154 Error using ODBC on Win2k

Thanks Randy. I just tried this, and found that I still get the same error message. Further, if I modify my client code to include "DBQ=CSDWORLD" or "DBQ=CSDWORLD.ena.us.exeperian.local" it has no effect.

Obviously the tns entry is effective, as when I test it from the ODBC setup in Administrative Tools for Win2k I successfully connect to the server, and can see in the network/log/listener.log (on the server) where it has connected.

Do I need a listener of any kind on the client machine to help my C++ application find the local tns entry when it uses ODBC?

It just seems like everything is already set up as it logically should work, but then again I'm fairly new to Oracle, so any advice is appreciated.

Regards,

Warren Wright
Dallas

"Randy Harris" <randy_at_SpamFree.com> wrote in message news:<uCFfc.2$mh1.1_at_newssvr16.news.prodigy.com>...
> It's very likely that your client is not adding the domain name to your net
> service alias. Create another entry in your client tnsnames.ora, exactly
> like the one above, but with only "CSDWORLD =" on the first line. Like
> this:
>
> CSDWORLD =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = w4533071)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = csdworld)
> )
> )
>
> HTH,
> Randy
Received on Fri Apr 16 2004 - 08:52:13 CDT