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

thanks Rick, Jim and Niall.... well i'm an oracle newbie .. all I did was to install 8.1.5 on my machine, configure a DSN and try connecting .. I haven't messed with the install (all defaults) and I certainly haven't configured anything ... but I tried it on 2 different machines and get the same thing .... but I will use your comments as a starting point now... net8 level 16 tracing ... that's what i'll figure out how to do next..... i'm running w2k sp1 by the way .... i seem to remember it working briefly before I applied that service pack... but i could be wrong abou that... cheers!

A

"Rick Wessman" <rwessman_at_rochester.rr.com> wrote in message news:soc66j32z37.fsf_at_rwessman-pc.us.oracle.com...
> 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.
Received on Thu Jan 25 2001 - 16:08:10 CST