do you have more than 1 tnsnames.ora? > 1 oracle home.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Julian Kooiker" <julian_at_digital-development.net> wrote in message
news:sGEn8.52902$LB3.6332255_at_amsnews02.chello.com...
> Hi,
>
> I am using oracle 8.1.7 for a web application. I use ASP to execute some
> queries. It always worked fine, but suddently I get the following error
(in
> my internet browser) more often:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not
resolve
> service name
>
> /ppi/beta1/ssltest/login.asp, line 32
>
> While I get this error I can login in sqlplus and other oracle tools. When
I
> reboot my server it sometimes works again, but sometimes it doesn't work?
I
> have no clue what to look at?
>
> I hope someone can help me.
>
>
> Julian Kooiker
>
>
>
Received on Mon Mar 25 2002 - 08:09:45 CST
