RE: Connectivity problems through IIS server.

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_at_rolta       To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>       
                    .com>                cc:                                           
                            
                    Sent by:             Subject:     RE: Connectivity problems 
through IIS server.                
                    root_at_fatcity.c                                                     
                            
                    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: 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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: okhalid_at_lmkr.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).