Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

C# - Microsoft.ACE.OLEDB.12.0 Provider is not Registered on the Local Machine in IIS7

Dec 21, 2012
Introduction

Here I will explain “the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine” problem solution in asp.net using C# and VB.NET.

Description

In previous articles I explained Asp.net, C#, VB.NET, SQL interview questions, Send values from one page to another page using QueryString, Joins in SQL Server, Highlight Gridview records based on search and many articles relating to Gridview, SQL ,jQuery,asp.net, C#, VB.NET. Now I will explain how to solve the problem of “the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine” in asp.net using C# and VB.NET.

In one application I got requirement like Read or Import data from excel sheet to gridview and upload excel data to SQL database once implementation completed I tested it in local everything working fine. After that I deployed application in server machine which contains IIS 7 version and tried to run then I got an error like "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine” that would be like as shown below

 
We can solve this error by using two methods

First Method
     
     1. Open IIS 7 manager and select the application pool corresponding to your application >> Right click on your Application Pool >> Select Advanced Settings like as shown below 

     2. Once settings opened >> Select an option Enable 32-bit Applications and change option to true

     3. Once you set this property restart your application pool and try I hope that problem will fix.
Still if the problem is not fixed check below method

Second Method

We will get this error whenever server was missing required component to read excel file. To solve this error you need to download the Access database component from Microsoft site and need to install it. Download software from below url


Once office access component installed in your server automatically this error will gone. Everything will work as you expected.

Note: Once this component installed in your server no need to restart your server.

If you enjoyed this post, please support the blog below. It's FREE!

Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

subscribe by rss Subscribe by RSS subscribe by email Subscribe by Email

16 comments :

rams said...

Excellent sir...Thank u so much...I got same error...after watching this article i got solution for my problemmmmm

Tarun Dudhatra said...

Hi ,

Very nice information. It helps me a lot.

Thanks

mobiles said...

thanks

Unknown said...

i am getting this error on server..
how to resolve ??

please help me sir.

Unknown said...

Don't Have Option Enable 32-Bit Application???

What To do ??

And After Installing "2007 Office System Driver: Data Connectivity Components"

Getting Same Error On Web

Unknown said...

Hi sir,
i am using office 2010, Project server 2010, vs 2010, i tried both the above methods but still am getting same error.

Thank u in advance sir
Ravi Kumar

Anonymous said...

hi, How to install "Microsoft Access Database Engine 2010 Redistributable" without Admin privilege?

http://www.microsoft.com/en-us/download/details.aspx?id=13255

Srikanth said...

Nice article..

phani said...

Yes, its true.. We had this issue for more than a year and did exactly what he has said. It started working fine.

Anonymous said...

Thanks. solves my problem. nice article.

bhupendrasinghsaini said...

thank you. solves my problem

Unknown said...

I have tried this and it worked for me but after that online reports stop showing the data, but when I change the 32 bit application to False again, then reports start showing the data but Oledb.ace.12.0 error comes back.
The setup is running on windows server 2008 R2 x64. Any solution???

Tiburonchat said...

thank you. solves my problem

Mirmalya said...

thank you. solves my problem

Fernando Orlando dos Santos said...

Tks! You save my life.

Anonymous said...

Download 2007 Office System Driver: Data Connectivity Components and install it .

change the connectionstring for .xlsx as

ConStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended
Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";

Give your Valuable Comments

Note: Only a member of this blog may post a comment.

© 2015 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.