2017-04-12

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

Reason 1 : Not install Office 2010

Solution  : Download and install Microsoft Access Database Engine 2010 Redistributable
https://www.microsoft.com/en-us/download/details.aspx?id=13255

Reason 2 : Your application was compile as AnyCPU, Your Windows is x64, Your Office 2010 is x86

Solution : Download and install Microsoft Access Database Engine 2010 Redistributable x64 version

HOWEVER, when you install x64 version, Windows might popup error message says you can't install x64 version unless uninstall x86 version

In this case, go to command mode to execute installation with parameter

C:/AccessDatabaseEngine_X64.exe /passive

So that both x64 and x86 installed on the same PC

沒有留言:

張貼留言