OraFAQ Forum: Networking and Gateways » ORA-12154: TNS:could not resolve service name

Home » RDBMS Server » Networking and Gateways » ORA-12154: TNS:could not resolve service name

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12154: TNS:could not resolve service name [message #66878]

Tue, 25 February 2003 04:42

Harshita
Messages: 1
Registered: February 2003

Junior Member

Hi,
I am working on Windows 2000 Sever which has Oracle 8i installed on it and has Multiple Oracle Home environment.

I am getting this following error when I am trying to establish ODBC conncetivity through ASP pages -

*******************************************************
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[[Microsoft]][[ODBC driver for Oracle]][[Oracle]]ORA-12154: TNS:could not resolve service name
*******************************************************

I am using Microsoft OLE DB Provider for ODBC Drivers
as an Provider and Microsoft ODBC driver for Oracle
as an driver on Windows 2000 Server.

When I test this connection through ODBC test it is
successful, but it fails while using it in ASP pages.

Thanks in Advance for your suggestions.
Harshita.

Report message to a moderator

Re: ORA-12154: TNS:could not resolve service name [message #66879 is a reply to message #66878]

Tue, 25 February 2003 06:24

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

did u try oracle ODBC?
and
ORA-12154: TNS:could not resolve service name
says that something is wrong with ur connectString..ie tnsnames.ora entries.
First the validity of the connectString.

Report message to a moderator

Re: ORA-12154: TNS:could not resolve service name [message #67402 is a reply to message #66879]

Thu, 24 June 2004 00:46

Faiza Izhar
Messages: 2
Registered: February 2004

Junior Member

Hi,
I have installed oracle8i on Win2K server by giving SID 'fhome' and same is the GDSN but when I try to connect with scott/tiger@fhome it gives the error of TNS.

Report message to a moderator

Re: ORA-12154: TNS:could not resolve service name [message #67428 is a reply to message #66878]

Mon, 19 July 2004 11:43

Phil
Messages: 32
Registered: March 2001

Member

I have been searching the internet for a solution to a similar problem. Here is what I was missing:
I needed a copy of SQLNET.ORA in my Oracle home directory (C:oracleora92networkadmin). This has something to do with defining domains. I grabbed a copy from our network server, and my ASP pages are working now.

Good luck.

Report message to a moderator

Re: ORA-12154: TNS:could not resolve service name [message #67429 is a reply to message #66878]

Tue, 20 July 2004 09:03

Adam
Messages: 15
Registered: October 2001

Junior Member

I am modifying an asp.net application that was on a sql server database to host it on oracle. Yesterday, and this morning, it would at least see the database. Now, I am getting this TNS ORA 12154 error, TNS: could not resolve the connect identifier specified. I don't believe I changed anything that should cause this. I am able to connect to the database just fine from my PL/SQL developer tool. I have verified that the tnsnames.ora entry is still the same as it was, and that all users have read permissions.

Any ideas?
Thanks in advance

Report message to a moderator

Previous Topic:	Service Name - Oracle
Next Topic:	Calling Transact SQL stored procedures via Oracle Transaprent Gateway

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 05:36:39 CDT 2024