ORA-12154 Fault

From: <peter_at_brosi.com>
Date: 18 Oct 2006 00:17:33 -0700
Message-ID: <1161155853.800488.103890@m73g2000cwd.googlegroups.com>

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 Received on Wed Oct 18 2006 - 02:17:33 CDT