Re: Oracle 8.1.7 works ... and not

From: daniel <test_at_test.com>
Date: Mon, 25 Mar 2002 19:59:45 -0000
Message-ID: <a7nvs4$iam$2@news7.svr.pol.co.uk>

you need to identify what has changed between it working and it failing. a 12154 error is when we cannot parse a tns entry in the tnsnames.ora file example;
sqlplus scott/tiger_at_db
if i don't have a "db" entry in my tnsnames.ora file then i will fail with a 12154
maybe the entry is "db.world" in which case my sqlnet.ora file may have changed
maybe my pathing is screwed up and i can't get the file maybe it's not there anymore

but cos u can connect sucessfully with oracle tools maybe you have changed the connect descriptor in your code?

have you changed the odbc data source in anyway?

try connecting with odbctest utility...

--
Regards,

Daniel.


"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 - 13:59:45 CST