Oracle connection through ASP

From: Ruud <gururuud_at_hotmail.com>
Date: 19 Sep 2002 03:22:36 -0700
Message-ID: <4db2e9a.0209190222.1db59b55@posting.google.com>

Hello,

I'm using an ASP script to connect to an ORACLE database. I'm trying to connect with the following script:

<%
Set cnnOracle = Server.CreateObject("ADODB.Connection") strConn = "Provider=MSDAORA.1; Data Source=myDataSource; User ID=myUserID; Password=myPassword"
cnnOracle.Open strConn
%>

However, i'm receiving the following error message all the time:

Error Type:
Microsoft OLE DB Provider for Oracle (0x80004005) Error while trying to retrieve text for error ORA-12154 /FundPartners/Corporate/crm/index7.asp, line 8 (LINE 2 IN THE LINES SHOWN) The SQLnet.log gives the following:

Fatal NI connect error 12560, connecting to:  (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\WINNT\System32\dllhost.exe)(HOST=EXCHANGE)(USER=IWAM_EXCHANGE))))

  VERSION INFORMATION:

	TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version

8.1.7.0.0 - Production
  Time: 18-SEP-2002 16:42:18
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12560
    TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS

    ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS

    nt secondary err code: 126
    nt OS err code: 0

Also by connecting through ORACLE ODBC I'm getting the ORA-12154 error. Using MS ODBC for ORACLE gives all kind of MS errors...

Any suggestions??!?!?!?

Thanx Received on Thu Sep 19 2002 - 05:22:36 CDT