Re: Help w/ Error #12154

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 9 Jul 1999 20:57:29 +0200
Message-ID: <931546609.24261.0.pluto.d4ee154e@news.demon.nl>

Your ODBC DSN has an Oracle service name which doesn't occurs in your %ORACLE_HOME%\net80\admin\tnsnames.ora. This file should match the listener.ora on the server, ie any entry in listener.ora should occur in tnsnames form in the tnsnames.ora.

Hth,

Sybrand Bakker, Oracle DBA

Rob Hickey <rfhickey_at_my-deja.com> wrote in message news:7m5d4v$gbe$1_at_nnrp1.deja.com...
> I'm trying to open Oracle 8.0 DB in Access 97 and getting the following
> after I try to login a password...
>
> [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not
> resolve service name (#12154)[Microsoft][ODBC Driver Manager] Driver's
> SQLSetConnectAttr failed (#0)
>
> Any help with similar experiences and fixes, would be helpful.
> Thanks in advance.
> --
> RFH
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Jul 09 1999 - 13:57:29 CDT