DB Connection problem

bri189a

bri189a

Well-known member
Joined
Sep 11, 2003
Messages
1,004
Location
VA
I have developed serveral apps, including one as a test after getting this error that use Access Database (2000) - same version as in error that I get which is the following:

System.Runtime.InteropServices.COMException: Class not registered
The .Net Data OLE DB Provider(System.Data.OleDb) requires Microsoft Data Access Components(MDAC). Please install Microsoft Data Access Components(MDAC) version 2.6 or later.

I have 2.7 SP1 installed. As I said I know it works because I even made a connection (copy and pasted connection string) afterwards in a brand new application. I thought maybe some weird permissions thing was going on since this was with ASP (first project in ASP that used Access rather than SQL Server), so I gave Everyone Full Control to test, but still same error. I would normally use SQL Server but this project does not allow me to.

Has anyone seen this before or have any ideas what I should look at? Tried msdn but couldnt find no help there (besides the obvious). For the heck of it I reinstalled 2.7 SP1 and still get same error - didnt think nothing would change.
 
All I can suggest is to reregister OLDDB32.DLL (Should be under C:\Program Files\Common Files\System\OLE DB) with REGSVR32.EXE. But if you can make a connection from a new application on the same PC, then I have no idea. :confused:
 
More Information

This is only happening on ASP.NET projects; on regular Windows Forms projects everything connects to the database fine. I have ensured, and even went to the extent of giving ASPNET, IWAM_MACHINE, and IUSR_MACHINE, and even Everyone Full Control for permissions thinking maybe that was having something to do with it.

Any ideas? Please! Thanks!
 
I now have MDAC 2.8 installed with Jet 8.0 and still the same thing. Ive scoured the internet and any similiar problems seem to be permission issues but again, I gave Everyone and ASPNET and machine accounts (even though they would fall under Everyone) Full control so I cant see where it would be a permission issue. Some posts on the internet suggest a setting in the machine.config file (changing process user to system vs. machine) but again, that does nothing either. Im really stumped on this one. Any help would be greatly appreciated!
 
Last edited by a moderator:
Back
Top