Oracle - IIS - Win2K - SP4

[Sam Jallad]

I installed W2K Service Pack 4. I have Oracle 8.1.7 installed on the server.
I also have the IIS running as well.. I can connect to my Oracle database
fine via SQL Plus and the ODBC text works fine. When I try to login to the
web site using ASP, I get the error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC driver for Oracle][Oracle]ORA-12640: Authentication adapter
initialization failed


Also, I did change sqlnet.authentication_services=(NONE)in sqlnet.ora file,
but then I was unable to start the database. Any suggestion how to fix that?
If not, How can I remove SP4? I want to go back to SP3..

[Sam Jallad]

dbDSN = "Provider=MSDASQL;Driver={Microsoft ODBC for
Oracle};dsn=odbcname;UId=username; Pwd=password;"

"Mark Schupp" <mschupp@ielearning.com> wrote in message
news:Om98mNGUDHA.2196@TK2MSFTNGP12.phx.gbl...

> If you specified that old file versions be backed up when you installed

sp4

> then you can uninstall it. If not you'll probably have to do a re-install

or

> repair of Windows 2000 and re-apply sp3.
>
> What is your connection string?
>
> --
> Mark Schupp
> --
> Head of Development
> Integrity eLearning
> Online Learning Solutions Provider
> [email]mschupp@ielearning.com[/email]
> [url]http://www.ielearning.com[/url]
> 714.637.9480 x17
>
>
> "Sam Jallad" <sjallad@autosmartcard.com> wrote in message
> news:%23lJHv4FUDHA.2312@TK2MSFTNGP12.phx.gbl...

> > I installed W2K Service Pack 4. I have Oracle 8.1.7 installed on the

> server.

> > I also have the IIS running as well.. I can connect to my Oracle

database

> > fine via SQL Plus and the ODBC text works fine. When I try to login to

the

> > web site using ASP, I get the error:
> >
> > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> >
> > [Microsoft][ODBC driver for Oracle][Oracle]ORA-12640: Authentication

> adapter

> > initialization failed
> >
> >
> > Also, I did change sqlnet.authentication_services=(NONE)in sqlnet.ora

> file,

> > but then I was unable to start the database. Any suggestion how to fix

> that?

> > If not, How can I remove SP4? I want to go back to SP3..
> >
> >

>
>

[TurkBear]

On Tue, 22 Jul 2003 10:33:12 -0400, "Sam Jallad" <sjallad@autosmartcard.com> wrote:

>I installed W2K Service Pack 4. I have Oracle 8.1.7 installed on the server.
>I also have the IIS running as well.. I can connect to my Oracle database
>fine via SQL Plus and the ODBC text works fine. When I try to login to the
>web site using ASP, I get the error:
>
>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
>[Microsoft][ODBC driver for Oracle][Oracle]ORA-12640: Authentication adapter
>initialization failed
>
>
>Also, I did change sqlnet.authentication_services=(NONE)in sqlnet.ora file,
>but then I was unable to start the database. Any suggestion how to fix that?
>If not, How can I remove SP4? I want to go back to SP3..
>

Changing the authentication to NONE will not prevent you from starting the database ( we use that all the time, no OS
authentication alowed), you just need to explicitly connect with

If on the server:
from a command prompt:
set ORACLE_SID = yoursid ( if more that one on server)
svrmgrl
connect internal and provide the sys password if prompted

If from a client
connect sys/password@tnsnames.ora as SYSDBA

Then issue your startup commands as usual..