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

Since an ORA-12638 can only be generated if Oracle Advanced Security is configured, I would bet that that is the problem. Try enabling Net8 tracing at level 16. The resulting trace file should give a clue as to what is going on.

                                    Rick

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> writes:

> Hi
>
> 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
> >
> >
> >
>
>
 

-- 
                                Thanks,
                                Rick
                                Rick Wessman
                                Server Security Group
                                Oracle Corporation
                                Rick.Wessman_at_oracle.com

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.