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

From: Mike Morgan <mike.g.morgan_at_home.com>
Date: Fri, 26 Jan 2001 04:06:47 GMT
Message-ID: <rJ6c6.46924$P5.1817084@news1.rdc1.il.home.com>

Check your SQLNET.ORA file in your client's ORACLE_HOME/network/admin directory. If NAMES.AUTHENTICATION_SERVICES=NTS is there, comment it out. We had similar problems which disappeared when NTS was not used for authentication - I believe it is the default configuration in a Windows environment.

Mike Morgan

"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 - 22:06:47 CST