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

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 25 Jan 2001 11:41:24 -0000
Message-ID: <94p3d6$2lc$1@soap.pipex.net>

the actual error you get is to do with authentication services. Is your sqlnet connection configured with any of the more advanced authentication options?

--
Niall Litchfield
Oracle DBA
Audit Commission UK


"Aaron Cody" <acody_at_pacbell.net> wrote in message
news:QwPb6.68$qU3.77917_at_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 Thu Jan 25 2001 - 05:41:24 CST