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.
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
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.
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.
 |
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 Email
|
|||
0 comments :
Note: Only a member of this blog may post a comment.