Problem after updating MDAC

[wackal]

Hi all,

Here's my problem. I have a local server that I use for all my development in ASP. Recently, I was trying to learn .NET so I installed the .NET framework and MDAC 2.6. I updated MDAC because I was trying to use a datagrid and I got an error message that I needed to update MDAC to 2.6.

Well, after the update, my regular ASP pages will not work. I keep getting this error message:

Microsoft JET Database Engine error '80004005'

Unspecified error

The error message always references my connection string, which is a DSN-less connection. What could be causing this problem? All my code worked fine until I updated MDAC. I also am running W2K with SP4.

[Staffa]

It could be that you have to update msjet##.dll as well

## = number

When I ran MDAC 2.6 it was in conjunction with msjet40.dll

run a find to locate this file on your PC and check the number of your msjet file.

[wackal]

thanks for the reply, I thought that might be the problem and I tried to update the Jet 4.0, but the server told me I already had the latest version

[Staffa]

I suggest you download and install the MDAC component checker from MS

from their site :
The Component Checker tool is designed to help you determine
installed version information and diagnose installation issues with
the Microsoft Data Access Components (MDAC)

I don't know if I can post the URL so it's in a sticky in your mailbox

[wackal]

thanks again staffa for the help. I checked the versions and I did have the most recent versions. For some reason, I had to adjust the security permissions for the temp and tmp folders on the server. Once I gave the IUSR read and write permissions for these folders, everything worked fine.

[wackal]

thanks again staffa for the help. I checked the versions and I did have the most recent versions. For some reason, I had to adjust the security permissions for the temp and tmp folders on the server. Once I gave the IUSR read and write permissions for these folders, everything worked fine.

[Staffa]

You're welcome and thank you too, you just taught me something new as well. ;o)