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# - The 'Microsoft.ACE.OLEDB.12' provider is not registered on the local machine.

Mar 10, 2015
Introduction:

Here I will explain how to solve the problem of “The 'Microsoft.ACE.OLEDB.12' provider is not registered on the local machine” in asp.net using c#.net, vb.net. Actually this problem occurred while accessing MS Access database 2007 or 2010 or higher version of access database in asp.net using c#.net, vb.net. 

Description:

In previous posts I explained insert & fetch data from access database in asp.net, create contactus form in asp.net, read connection string from web.config file in asp.net, use multiple web.config files in asp.net with example, encrypt and decrypt connection string in asp.net and many articles relating to solve errors in asp.net using c#.net, vb.net and SQL Server, IIS, etc. Now I will explain how to solve the problem of “The 'Microsoft.ACE.OLEDB.12' provider is not registered on the local machine” in asp.net using c#.net, vb.net.

I written one program to access data from MS Access database in asp.net using c#.net, vb.net at that time I got error “The 'Microsoft.ACE.OLEDB.12' provider is not registered on the local machine” like as shown below

To solve this problem we need to install office system drivers based on Access database version

First install office system 2007 drivers from this link Download office 2007 system drivers

Once you finish installation of office 2007 drivers now you need to install office 2010 system drivers from this link Download office 2010 system drivers

In Office 2010 drivers you need to select required version based on your visual studio version either 32 bit or 64 bit and install the drivers like as shown below


In case if you are using Access 2013 you need to install Office 2013 system drivers from this link Download office 2013 redistributable version

I hope it helps you to solve your problem. Happy Coding………

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

0 comments :

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.