cannot connect to an oracle

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have problems when I try to connect to my Oracle db from VS 2003. I get
this error: ORA-12154: TNS:could not resolve the connect identifier specified

My tnsnames.ora-file I have this text:
MALL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =
Z9100774.ne.ad.ner.capgemini.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mall)
)
)

What can be the problem?

Thanks
Julia
 
Julia said:
Hi
I have problems when I try to connect to my Oracle db from VS 2003. I get
this error: ORA-12154: TNS:could not resolve the connect identifier
specified

My tnsnames.ora-file I have this text:
MALL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =
Z9100774.ne.ad.ner.capgemini.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mall)
)
)

What can be the problem?

Thanks
Julia
Click to expand...

Can you connect from a different client using this tnsnames entry?
 
Hi,
and thanks for your reply.

I can connect to MALL using Enterprise Manager and SQLPlus is that what you
mean? Or do you mean from another computer? That I havent tried.

/Julia
 
What's your connection string?

Also, I'd do a search on all the TNSNames.ora files on the machine (inside
an admin folder). Multiple homes can cause this error
 
¤ Hi
¤ I have problems when I try to connect to my Oracle db from VS 2003. I get
¤ this error: ORA-12154: TNS:could not resolve the connect identifier specified
¤
¤ My tnsnames.ora-file I have this text:
¤ MALL =
¤ (DESCRIPTION =
¤ (ADDRESS = (PROTOCOL = TCP)(HOST =
¤ Z9100774.ne.ad.ner.capgemini.com)(PORT = 1521))
¤ (CONNECT_DATA =
¤ (SERVER = DEDICATED)
¤ (SERVICE_NAME = mall)
¤ )
¤ )

There could be any number of issues. If you're working with an ASP.NET app it could be a permissions
issue. Otherwise I would verify that you are configured to read the correct tnsnames.ora file.


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top