Category: Visual Studio

26 Oct 2014 03:20

Joined:	03/03/2013
Level:	Silver
Points:	115

Points:	1

Microsoft.oledb.12.0' provider is not registered on the local machine

Are you looking for a way to resolve error Microsoft.oledb.12.0' provider is not registered on the local machine ? then read this thread to know more about it

when i am using .net application through my local machine i am getting this error how should i resolve it

#753075

26 Oct 2014 11:59

Joined:	08/07/2010
Level:	Gold
Points:	6482

Points:	2

it looks like the issue is with the local machine. try to do perform below work around. it should work fine.

t might be because you are running 64-bit windows and there are no drivers that run 64-bit. So to solve it you need to change your build configuration to x86. You can do that on the project properties dialog under "Compile>Advanced Compile Options...>Target CPU". Change it to "x86". Then clean the solution and rebuild your application.
or if the above solution does not work
Install the Data Connectivity Components from http://www.microsoft.com/downloads/en/confirmation.aspx?familyId=7554f536-8c28-4598-9b72-ef94e038c891&displayLang=en

Miss. Jain
Microsoft Certified Technology Specialist in .Net

#753086

26 Oct 2014 23:55

Joined:	12/11/2009
Level:	Gold
Points:	43848

Points:	2

Hi,
I believe you are using 64 bit machine but using 32 bit configuration. There can be multiple reasons for this error, so I want you to try below options,

help.webcontrolcenter.com/kb/a1114/how-to-enable-32-bit-application-pool-iis-7-dedicatedvps.aspx
connectionstrings.com/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine/

Let me know in case the above suggestions doesn't work.

Regards,
Asheej T K

#753102

27 Oct 2014 02:41

Joined:	13/06/2007
Level:	Gold
Points:	21327

Points:	2

I believe its a 64 and 32 bit confusion, just change the Solution Platform from "Any CPU" to "x86" and Rebuild your code. it will resolve your problem.
Apart from above solution try out some below links
https://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine?forum=vstsdb

https://www.connectionstrings.com/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine/

http://www.codeproject.com/Tips/417397/OLEDB-Provider-is-Not-Registered-on-the-Local-Mach

Thanks
Koolprasd2003
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS]

Microsoft.oledb.12.0' provider is not registered on the local machine

About dotnetspider.com

Quick Links

General

Services