cannot connect to an oracle

26 Jan 2006 4:42 PM

Julia

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

26 Jan 2006 5:57 PM

pvdg42

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

Can you connect from a different client using this tnsnames entry?

26 Jan 2006 9:01 PM

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?
>
>
>

27 Jan 2006 9:15 PM

Eric

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

30 Jan 2006 5:26 PM

Paul Clement

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)