Databases connections not working more with all web sites

Hello World,

MS NT 2000 Server (+with all latest SP).
asp.dll version: 5.0.2195.6672
jet.dll version: 5.0.2134.1

All usually working before well, but accidentally crashed by undetermined
reason:

Databases connections, both, for MS SQL Server 2000 (SP1) and MS Access 2000
databases stop working under all web sites on web server.

Affect only IIS applications.

if trying to open MS Access 2000 databases:

Microsoft JET Database Engine error '80004005'
Unspecified error

In connection string, while try to work with MS Access db:
Set XXX = Server.CreateObject ("ADODB.Connection")
XXX.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=XXXXX"
XXX.CursorLocation = 3 // could be vary
XXX.CommandTimeout = 60
XXX.Open <-- ERROR HERE


if trying to open MS SQL Server 2000 and MS Access 2000 databases:

ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed

Set XXX = Server.CreateObject ("ADODB.Connection")
XXX.Open "DSN=XXXXXXXX;uid=XXXXX;pwd=XXXXXXX;" <-- ERROR HERE



ADO and JET testing from WIN32 Application indicate that they are working
and installed well
- Jet 4 installed
- ADO version 2.7
- MDAC version 2.7.9040.2


Reinstalling of Microsoft Data Access Components (MDAC) 2.8 are not help.
Reinstalling of IIS are not help.

Re: Databases connections not working more with all web sites

First check for permission problems. Temporarily set the anonymous user
account for one of the sites with a problem to an account with administrator
rights (not sure is you need to re-boot but I would just to make sure). If
the site works then you have a permission problem that you need to track
down.

See http://www.aspfaq.com/show.asp?id=2009

--
--Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com

"Andrew Zamkovoy" wrote in message
news:uF1yF26uEHA.3276@TK2MSFTNGP15.phx.gbl...
> Hello World,
>
> MS NT 2000 Server (+with all latest SP).
> asp.dll version: 5.0.2195.6672
> jet.dll version: 5.0.2134.1
>
> All usually working before well, but accidentally crashed by undetermined
> reason:
>
> Databases connections, both, for MS SQL Server 2000 (SP1) and MS Access
> 2000
> databases stop working under all web sites on web server.
>
> Affect only IIS applications.
>
> if trying to open MS Access 2000 databases:
>
> Microsoft JET Database Engine error '80004005'
> Unspecified error
>
> In connection string, while try to work with MS Access db:
> Set XXX = Server.CreateObject ("ADODB.Connection")
> XXX.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=XXXXX"
> XXX.CursorLocation = 3 // could be vary
> XXX.CommandTimeout = 60
> XXX.Open <-- ERROR HERE
>
>
> if trying to open MS SQL Server 2000 and MS Access 2000 databases:
>
> ADODB.Connection error '800a0e7a'
> Provider cannot be found. It may not be properly installed
>
> Set XXX = Server.CreateObject ("ADODB.Connection")
> XXX.Open "DSN=XXXXXXXX;uid=XXXXX;pwd=XXXXXXX;" <-- ERROR HERE
>
>
>
> ADO and JET testing from WIN32 Application indicate that they are working
> and installed well
> - Jet 4 installed
> - ADO version 2.7
> - MDAC version 2.7.9040.2
>
>
> Reinstalling of Microsoft Data Access Components (MDAC) 2.8 are not help.
> Reinstalling of IIS are not help.
>
>
>
>
>

Re: Databases connections not working more with all web sites

Hello Mark,

Unfortunately, permission check not help.
Inetpub folders (and subfolders), database folders (and MS Access files) has
permission for IUSR_, IWAM_. Adding "Everyone" user not help.

With best regards,


"Mark Schupp" wrote in message
news:uok$WeDvEHA.1860@TK2MSFTNGP15.phx.gbl...
> First check for permission problems. Temporarily set the anonymous user
> account for one of the sites with a problem to an account with
administrator
> rights (not sure is you need to re-boot but I would just to make sure). If
> the site works then you have a permission problem that you need to track
> down.
>
> See http://www.aspfaq.com/show.asp?id=2009
>
> --
> --Mark Schupp
> Head of Development
> Integrity eLearning
> www.ielearning.com
>
> "Andrew Zamkovoy" wrote in message
> news:uF1yF26uEHA.3276@TK2MSFTNGP15.phx.gbl...
> > Hello World,
> >
> > MS NT 2000 Server (+with all latest SP).
> > asp.dll version: 5.0.2195.6672
> > jet.dll version: 5.0.2134.1
> >
> > All usually working before well, but accidentally crashed by
undetermined
> > reason:
> >
> > Databases connections, both, for MS SQL Server 2000 (SP1) and MS Access
> > 2000
> > databases stop working under all web sites on web server.
> >
> > Affect only IIS applications.
> >
> > if trying to open MS Access 2000 databases:
> >
> > Microsoft JET Database Engine error '80004005'
> > Unspecified error
> >
> > In connection string, while try to work with MS Access db:
> > Set XXX = Server.CreateObject ("ADODB.Connection")
> > XXX.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > Source=XXXXX"
> > XXX.CursorLocation = 3 // could be vary
> > XXX.CommandTimeout = 60
> > XXX.Open <-- ERROR HERE
> >
> >
> > if trying to open MS SQL Server 2000 and MS Access 2000 databases:
> >
> > ADODB.Connection error '800a0e7a'
> > Provider cannot be found. It may not be properly installed
> >
> > Set XXX = Server.CreateObject ("ADODB.Connection")
> > XXX.Open "DSN=XXXXXXXX;uid=XXXXX;pwd=XXXXXXX;" <-- ERROR HERE
> >
> >
> >
> > ADO and JET testing from WIN32 Application indicate that they are
working
> > and installed well
> > - Jet 4 installed
> > - ADO version 2.7
> > - MDAC version 2.7.9040.2
> >
> >
> > Reinstalling of Microsoft Data Access Components (MDAC) 2.8 are not
help.
> > Reinstalling of IIS are not help.
> >
> >
> >
> >
> >
>
>