Microsoft.ACE.OLEDB.12.0 provider is not registere

问题:

My application is written in C# and uses Ms-Access 2003 and I want it to run properly in 64-bit Windows installation. I use the data provider as ACE.OLEDB.12.0 in the connection string, but it still gives the exception that Microsoft.ACE.OLEDB.12.0 provider is not registered though I have installed the Microsoft Access Databse Engine 2010 (32-bit) in the target machine (As the target machine's Office installation is 32-bit).

I followed to the following post Microsoft.ACE.OLEDB.12.0 provider is not registered and many other posts in msdn and other microsoft sites and the problem solves as they say to compile to x86. I want to know whether there is another way of solving this problem which does not require compiling to x86...

回答1:

You don't have to compile for x86, but you need to install the 64-bit Access OLEDB provider on a 64-bit box. It's available here: Microsoft Access Database Engine 2010 Redistributable

回答2:

I had this same issue on a 64-bit, but following advice on http://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, I installed the Office 2007 version of these components from http://www.microsoft.com/download/en/confirmation.aspx?id=23734, which worked flawlessly.