Re: ORA-12154 Fault

Hallo,

i read the documentation and i clean my sqlnet.ora and my tnsname.ora after this the ORA-12154 Fault is soluted

but this Message is not soluted

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed IM006 0 [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (#0)"

did you know the reason for this fault ?

if i have a new workstation where i only install ora9 it works fine

on this ws we installed ora8 and ora 9 but the deinstallation of ora8 is not enough

may be you can help me

thanks

peter brosi

sybrandb schrieb:

> 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 - 06:52:14 CDT