Re: ORA-12154 Fault

From: sybrandb <sybrandb_at_gmail.com>
Date: 18 Oct 2006 00:41:22 -0700
Message-ID: <1161157282.007472.79730@k70g2000cwa.googlegroups.com>

peter_at_brosi.com wrote:
> Hallo,
>
> we have installed a new oracleserver 9.2 with patch 9.2.0.6
>
> i also have installed the new clientsoftware on a xp and a win2000
> workstation.
>
> If i want to make a odbc connection to oracle with acces i got a fault
>
> "ODBC--call failed.
> [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not
> resolve service name (#12154)
> [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
> IM006 0 [Microsoft][ODBC Driver Manager]
> Driver's SQLSetConnectAttr failed (#0)"
>
>
> This fault is only on the win2000 workstation
>
> who know what is the reason for this fault.
>
> a tnsping to the server is no problem
> a connection with sqlplus is no problem
>
> thanks for your help
>
> Peter Brosi

Please search the archives of this group and/or read up the Troubleshooting chapter in the Net Administrators manual up on http://tahiti.oracle.com.
This is a frequent error, and the solution has been documented abundantly.
Basically, you must have multiple tnsnames.ora files floating around.

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Wed Oct 18 2006 - 02:41:22 CDT