i have done this some time back . you need to setup
the ODBC ADMINISTRATOR and make a DSN on the client side
or the server side to access the oracle database using ASP. simply using
the SQL NET won't work if u'r using ASP.
'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'
Omar Khalid
Software Engineer
LMK Resources
Voice: 111-101-101*780
Mobile: 0333-510-4465
Web: www.lmkr.com
'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'
"shirish"
<shirish@rolta To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
.com> cc:
Sent by: Subject: RE: Connectivity problems
through IIS server.
[EMAIL PROTECTED]
om
07/20/2001
09:42 PM
Please respond
to ORACLE-L
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
