-
Notifications
You must be signed in to change notification settings - Fork 300
microsoft.ACE.oledb.12.0 error
subsci edited this page Jul 25, 2017
·
3 revisions
System.InvalidOperationException: 未在本地计算机上注册“microsoft.ACE.oledb.12.0”提供程序。
pls install 2007 Office system driver http://download.microsoft.com/download/7/0/3/703ffbcb-dc0c-4e19-b0da-1463960fdcdb/AccessDatabaseEngine.exe
OR to check if you already have ACE on your system, run Powershell (both x64 and x86)
> (New-Object system.data.oledb.oledbenumerator).GetElements() | select SOURCES_NAME, SOURCES_DESCRIPTION
Turns out I had x64 ACE as revealed in PowerShell. So rather than blindly install, I changed the configuration in VS2015 LinqToExcel v1.11. I used Configuration Manager to explicitly build for x64; and that corrected the error.