General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0

Up until the end of last week the webserver was working fine.

However since all the recommended patches were put on the Windows 2000 Server running IIS 5 the following error is now displayed:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x380 Thread 0x460 DBC 0x2013f84 Jet'.

/library/inc_dbconnection.asp, line 10

The only thing that changed was the recommended updates were put on.

Any ideas?

We have the same problem since 2 weeks.... the website itself is not updated, only the server patching. Same connecting problems. After a reboot the site will work a few hours and the error will come back.

I have not found any info on the technet site about this... who could help?

make sure your connection string has the right path.

Give the IUSR account write permissions to the directory where the Access database is and to the windows %temp% directory.

did all this before... and why de website will work a few hours after rebooting the servers and stop suddenly? Only after a time this error appears.

Gtz.

Hans

If your permissions heirarchy (spelled correctly?) in your web directories and any other directories which house your DB's are not set-up correctly, your permissions can be reset everytime the server is rebooted. I used to encounter that a lot in the past.

[EDIT] - Oops! Also, many updates will change some settings you made to your web site and it's structure. The worst I have seen so far is upgrading to 2003 FrontPage Extensions, and the newset MDAC update. They were a nightmare!

Hello all,

Perhaps a tad bit late but I had the same error when I tried to login to my localhost or thrue the web to the website. I set all permissions correctly but it didn't help.

The cause for my problems were eventually linked to my firewall. Aparently closing down my firewall blocked my pc for the iwam usr etc. Even with an admin account, logging into the website didn't work. (NT authorisation)

The solution for the problem was to simply configure the firewall correctly to allow more rights to web users. (The firewall I used was Black Ice.)

Hope to have helped others with the firewall solution.

Hi,

I have the same problem as yours. I don't use ODBC driver but Jet Driver and that works;

Some code ex:

------------------------
......
svrpath = server.MapPath("/")
constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & svrpath & "\database\MyDBAccess.mdb;Persist Security Info=False"

Set ConDb1=Server.CreateObject("ADODB.Connection")
ConDb1.Open conStr
......
------------------------

Good luck!

Yeah, we ended up moving over to the very same driver until we upgraded to .Net & SQL Server.

Hey

Thank you very much..it worked..i was facing the same problem and couldnt find any solution..I just registered myself to this forum so i could write you thank you note ///

Thanks
Take care
menon

This really help me so much!! Thank you!!!