RE: Connectivity problems through IIS server.

hi

while connecting to oracle thro' ASP, u need to specify the TNSname. as far as i know the tnsname is case sensative(when using with ASP) so plz check the tnsname entry.
also check the same with dsn entries..

hope this helps ..

thanks and regards !
Shirish Khapre, SE Rolta India Ltd.
Off Ph No. (+91) (022) 8326666,8262222,8300568 Ext'n 2730
Minds are like parachutes. They only function when they are open

-----Original Message-----
Behalf Of Naik,
Sandesh S
Sent: Thursday, July 19, 2001 8:10 PM
To: Multiple recipients of list ORACLE-L

Dear List,
 One of our developers is getting following error while trying to connect
using IIS Server (4.0) to oracle Database 8.1.6.2.0. I think he is using ASP
program to connect to database.
 I am able to connect though sqlplus.exe from that machine but not through
the IIS Server connection. Is there anything else you have to set in IIS
server to get right tnsnames.ora
 Can you help?
The error message:
Microsoft OLE DB Provider for Oracle error '80004005'
ORA-12154: TNS:could not resolve service name /getdate.asp, line 33

Thanks

Sandesh

--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Naik, Sandesh S
  INET: sandesh.naik_at_qwest.com

Fat City Network Services    -- (858) 538-5051
FAX: (858) 538-5051
San Diego, California        -- Public Internet
access / Mailing Lists
--------------------------------------------------
------------------
To REMOVE yourself from this mailing list, send an
E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L


(or the name of mailing list you want to be

removed from).  You may
also send the HELP command for other information


(like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: shirish
  INET: shirish_at_rolta.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).