Getting error "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine"
PROBLEM DESCRIPTION:
While I was trying to connect to an Access Database from Visual Studio 2010 on my Windows 7 x64 server, I got the following error message,
Server Error in '/myCalendar' Application.
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
SOLUTION:
After a detailed research on the above error message, I was able to identify that the 64-bit framework dlls weren’t able to 32-bit versions of the 'Microsoft.ACE.OLEDB.12.0' provider modules.
Since I was running Visual Studio on a 64-bit machine, IIS 7 is not (by default) serving 32-bit applications. However, I noticed that the database engine operated on 32-bit. I followed these steps to fix the issue:
1. Open the IIS 7.5 manager and select the application pool corresponding to your web application.
2. Right click the application pool and select ‘Advanced settings’.
3. Select the field ‘Enable 32-bit applications’ and change it to 'true'.
4. Restart your application pool and access your application to fix the error you saw.
Happy debugging!
Comments
- Anonymous
February 28, 2012
Thanks! Was stuck on it for last 2-3 hours and it worked. - Anonymous
March 25, 2012
good oneand helpful article ,thx - Anonymous
March 25, 2012
thanks for the helpful post - Anonymous
April 03, 2012
Thank you very much..It is very help full for me.. - Anonymous
June 21, 2012
it does not help for me! I receive this error after run a windows application who's try to read a excel file - Anonymous
June 27, 2012
Excellet post. It helped me to resolve the issue in seconds. Thanks a lot. - Anonymous
January 14, 2013
Thank you for the refresher. I had had this problem before a while back and fixed it, but came across it again and was stumped. Just reading a few lines here made me remember. - Anonymous
February 01, 2013
Awsome. Save my life, this article! - Anonymous
February 07, 2013
Thanks A lot ....:) 4 provide me right way to remove this Error i stuck on this whole day - Anonymous
May 04, 2013
Thanks! It is very helpful. - Anonymous
July 02, 2013
Tried everything but this worked! - Anonymous
July 04, 2013
Excelent! thanks for the solution. - Anonymous
July 16, 2013
Thanks! - Anonymous
September 18, 2013
thanks a lot u saved my life .............. - Anonymous
October 24, 2013
Thank you very much, Really it is very help full. - Anonymous
February 09, 2014
thanks:finally problem solved - Anonymous
March 24, 2014
Thanks Alot Nice Post. - Anonymous
April 07, 2014
Thanks. - Anonymous
May 20, 2014
Hi Friends,I was getting the same error on local pc and on server, I did full R & D and finally I found that we need to install below setup which resolves the error.www.microsoft.com/.../details.aspxENJOY !!!Thanks and Regards,Rohit Rathodanrorathod@gmail.com - Anonymous
August 18, 2014
Thanks. It got worked for me. - Anonymous
October 27, 2014
Nice, but incompatible with Sharepoint 2013/2010...:( - Anonymous
November 24, 2014
Thanks for the post. I was stuck for few hours over this issue.