Oracle 8i ODBC from ASP/IIS ... flaky connections

From: Aaron Cody <acody_at_pacbell.net>
Date: Wed, 24 Jan 2001 21:59:28 -0800
Message-ID: <QwPb6.68$qU3.77917@news.intnet.net>

hello
I'm running Oracle 8i on w2k and I've configured an ODBC datasource to connect to the database from my ASP script.

here's the vbscript:

Dim objConn 'connection to access database Set objConn = Server.CreateObject("ADODB.Connection")

Dim cnnDSN
cnnDSN = "DSN=OraDSN;UID=SYSTEM;PWD=manager;"

if IsObject (objConn) then
objConn.Open cnnDSN
else
Response.Write("no DB connection !")
end if

and sometimes it works, but sometimes I get this:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Oracle][ODBC][Ora]ORA-12638: Credential retrieval failed

any ideas ???

thanks
A Received on Wed Jan 24 2001 - 23:59:28 CST