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

  • Thread starter Thread starter mprarad
  • Start date Start date
M

mprarad

Guest
Hi I am having issues with the 'Microsoft.ACE.OLEDB.12.0' provider for my project that is in VS 2010 c#.

I have found a couple of solutions online:

downloading the Microsoft Access Database Engine 2010 Redistributable or the 2007 version.

(This did not work)

Changing target platform to x86 for all solutions within project:

This did not work either because i get: System.BadImageFormatException: Could not load file or assembly '(Solution Name)' or one of its dependencies. An attempt was made to load a program with an incorrect format.

However, I copied the same logic over to a project i created in Visual Studio 2012 and it was able to use the 'Microsoft.ACE.OLEDB.12.0' provider without having to switch the target platform to x86 rather it is set to AnyCPU...?

So, now I'm confused on whether i am doing this correctly or not.

I would like my VS 2010 application to use the 'Microsoft.ACE.OLEDB.12.0' provider since the 'Microsoft.Jet.OLEDB.4.0' is currently not working due to the latest Microsoft update on October 18th 2017.


How can i achieve this?


Thank You

Continue reading...
 
Back
Top