Delen via

Getting error "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine"

  • Artikel

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.