|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
cannot connect to an oracleI 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
Show quote
"Julia" <Ju***@discussions.microsoft.com> wrote in message Can you connect from a different client using this tnsnames entry?news:DC656665-5C13-4DCB-9CC7-7C4AC0692450@microsoft.com... > 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 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 Show quote "pvdg42" wrote: > > "Julia" <Ju***@discussions.microsoft.com> wrote in message > news:DC656665-5C13-4DCB-9CC7-7C4AC0692450@microsoft.com... > > 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 > > Can you connect from a different client using this tnsnames entry? > > > 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 Show quote "Julia" <Ju***@discussions.microsoft.com> wrote in message news:DC656665-5C13-4DCB-9CC7-7C4AC0692450@microsoft.com... > 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 On Thu, 26 Jan 2006 08:42:06 -0800, "Julia" <Ju***@discussions.microsoft.com> wrote: ¤ 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) |
|||||||||||||||||||||||