Re: HELP !!!! [Oracle]ORA-12154: TNS:could not resolve service name

Hi,

Check if OracleTNSListener service is running. That service is supposed to resolve the name. Also check your TNSNAMES.ORA file.

For Oracle 8.0.5 on NT, the name of the service is OracleTNSListener80.

HTH
Bandoba

Rene Rijbroek wrote:
>
>
> PLEASE Help Me,
>
> I have an oracle database running on a window NT 4.0 enterprise server.
> Everything was ok and working fine. Until suddenly i can not access the
> oracle database using ODBC. When i do try, i get the following error:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not
resolve
> service name
>
> I have tried everything, newest ODBC drivers, windows NT sp6 etc. etc.
etc.
> Can anyone help me, i saw the exact question posted on a message board a
> while back with no answers at all. Please, is there somebody who knows
how
> to solve this problem. The only thing i can think of is to reinstall the
> whole computer, there has to be an other way.
>
> Thx in advance, Rene Rijbroek
>
>

--
Posted via CNET Help.com
http://www.help.com/ Received on Thu Dec 23 1999 - 17:30:04 CST