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

Andrew Zamkovoy wrote:

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

You also should reinstall the Jet components, which are separate from the
MDAC components.

Due to Windows File Protection in W2K, some MDAC problems can only be solved
by running Windows Setup and choosing the "Repair" option.


Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: Databases connections not working more with all web sites

Hello Everyone,

Thank you for your help.

Finally was resolved. After second reinstalling MDAC, and adding user
"Everyone" on WINNT and Program Files folder.

With best regards,

"Bob Barrows [MVP]" wrote in message
news:eaIystNvEHA.3972@TK2MSFTNGP10.phx.gbl...
> Andrew Zamkovoy wrote:
>
> >
> >
> > Reinstalling of Microsoft Data Access Components (MDAC) 2.8 are not
> > help. Reinstalling of IIS are not help.
>
> You also should reinstall the Jet components, which are separate from the
> MDAC components.
>
> Due to Windows File Protection in W2K, some MDAC problems can only be
solved
> by running Windows Setup and choosing the "Repair" option.
>
>
> Bob Barrows
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>