bri189a Posted June 1, 2004 Posted June 1, 2004 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 couldn't find no help there (besides the obvious). For the heck of it I reinstalled 2.7 SP1 and still get same error - didn't think nothing would change. Quote
bob01900 Posted June 1, 2004 Posted June 1, 2004 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: Quote
bri189a Posted June 3, 2004 Author Posted June 3, 2004 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! Quote
bri189a Posted June 3, 2004 Author Posted June 3, 2004 (edited) I now have MDAC 2.8 installed with Jet 8.0 and still the same thing. I've 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 can't 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. I'm really stumped on this one. Any help would be greatly appreciated! Edited June 3, 2004 by bri189a Quote
Administrators PlausiblyDamp Posted June 3, 2004 Administrators Posted June 3, 2004 It may be worth running the MDAC checker tool from MS http://www.microsoft.com/downloads/details.aspx?familyid=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en just to see if it reports any errors Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
bri189a Posted June 3, 2004 Author Posted June 3, 2004 It may be worth running the MDAC checker tool from MS http://www.microsoft.com/downloads/details.aspx?familyid=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en just to see if it reports any errors Already past that point...nothing came back out of the ordinary... Thanks though... Quote
OnTheAnvil Posted March 8, 2005 Posted March 8, 2005 bri189a, Did you ever find a solution? I'm having a similar problem. Thanks, OnTheAnvil Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.