Class not registered at ADOX.CatalogClass.Create(String ConnectString)

Question

Hi,
I added reference to COM Component Microsoft ADO Ext. 2.8 for DDL and Security which added a wrapper DLL Interop.ADOX.dll in project references in a web application to create MS Access database dynamically. It all works fine in development environment ( VS 2008 + Win 2003 Server. + 32-bit Machine)
The aformentioned web application is deployed on IIS 7 + Win server 2008 + 64 - bit machine, where it throws following exception
System.Runtime.InteropServices.COMException (0x80040154): Class not registered at ADOX.CatalogClass.Create(String ConnectString)............... We have tried followings on the targeted web servers

1. 1.) Installed Access run time

2.) Installed Access full install

3. ) Registered MSADOX.dll using REGSVR32 ( this fix was mentioned on number of forums)

But, still no luck. Please, let me know what I am missing here to fix this.

Thanks.

abdul rehman · Answer

Bechir thanks for your reply. I was able to fix the same day after couple of hours. Below is code snippet ADOX.CatalogClass db = new CatalogClass(); // Works fine db.Create(JET connection string); // Throws exception. The problem is due to JET. JET doesn't have support for 64-bit. To fix this we changed App Pool configuration from 64-bit to 32-bit. That was all to fix this. Apparently, exception information is misleading.

Bechir Bejaoui · Answer

Verify whether it is any dependance to other dlls that your application requires and ignored by you when you moved the project to the other machine,try to remember or check this issue first make use of the DepencyWalker.exe to check this. I guess 80% this is your problem, but it may be caused by other factors. In both situations I expect an answer from you because I'm intersted to find a solution to this problem