Last post Sep 28, 2010 05:10 AM by adasilva
Sep 24, 2010 06:42 AM|adasilva|LINK
I have installed my web application on a customer site which is using a 64 bit Windows 2008 machine.
The problem that I am having is that when the application tries to access a microsoft Access database it gets the following error:
"Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine". I had this problem before on my development machine which is a Windows 7 64bit OS. What had to do is change the application pool to Enable 32 bit applications and it works fine.
But I have done the same on the client machine and its not working.
I have also download the client database to my machine and had no problem connecting to it. to do a test I disabled the 32bit application on my IIS and I could recreat the customer's problem. Enabling again works fine.
Now my question is why it does not work on the customer's site? I have configure IIS the same way!
Sep 28, 2010 04:21 AM|Wencui Qian - MSFT|LINK
That seems strange. Usually, we just need to enable 32bit mode in application pool to run the provider correctly. But if this still can't resolve the problem, I suggest you to report it to Microsoft to get more help:
Sep 28, 2010 05:10 AM|adasilva|LINK
thanks for your replies.
I have figured out!
Not only you need to enable 32bit apps on IIS but you have also ensure that the site is on the trusted site list on IE. Also make sure that the user account has Read/Execute and Read on the file.