Prøv at kigge dette ekstremt populære spørgsmål og især dette svar:
https://stackoverflow.com/a/32293408/3527297Bemærk PowerShell scriptet, der lister, hvad du har installeret:
(New-Object system.data.oledb.oledbenumerator).GetElements() | select SOURCES_NAME, SOURCES_DESCRIPTIONDet kan køres både i 64-bit PowerShell og 32-bit PowerShell (x86).
Her er, hvad jeg har i 64-bit:
SOURCES_NAME SOURCES_DESCRIPTION
------------ -------------------
SQLOLEDB Microsoft OLE DB Provider for SQL Server
MSDataShape MSDataShape
SQLNCLI11 SQL Server Native Client 11.0
Microsoft.ACE.OLEDB.12.0 Microsoft Office 12.0 Access Database Engine OLE DB Provider
Microsoft.ACE.OLEDB.16.0 Microsoft Office 16.0 Access Database Engine OLE DB Provider
ADsDSOObject OLE DB Provider for Microsoft Directory Services
MSOLEDBSQL Microsoft OLE DB Driver for SQL Server
MSOLEDBSQL Enumerator Microsoft OLE DB Driver for SQL Server Enumerator
SQLNCLI10 SQL Server Native Client 10.0
SQLNCLI11 Enumerator SQL Server Native Client 11.0 Enumerator
SQLNCLI10 Enumerator SQL Server Native Client 10.0 Enumerator
Windows Search Data Source Microsoft OLE DB Provider for Search
MSDASQL Microsoft OLE DB Provider for ODBC Drivers
MSDASQL Enumerator Microsoft OLE DB Enumerator for ODBC Drivers
MSOLAP Microsoft OLE DB Provider for Analysis Services 14.0
MSOLAP Microsoft OLE DB Provider for Analysis Services 14.0
SQLOLEDB Enumerator Microsoft OLE DB Enumerator for SQL Server
MSDAOSP Microsoft OLE DB Simple Provider
MSOLAP Microsoft OLE DB Provider for Analysis Services 13.0
MSOLAP Microsoft OLE DB Provider for Analysis Services 13.0
og i 32-bit:
SOURCES_NAME SOURCES_DESCRIPTION
------------ -------------------
SQLOLEDB Microsoft OLE DB Provider for SQL Server
MSDataShape MSDataShape
SQLNCLI11 SQL Server Native Client 11.0
ADsDSOObject OLE DB Provider for Microsoft Directory Services
MSOLEDBSQL Microsoft OLE DB Driver for SQL Server
SSISOLEDB OLE DB Provider for SQL Server Integration Services
MSOLEDBSQL Enumerator Microsoft OLE DB Driver for SQL Server Enumerator
SQLNCLI10 SQL Server Native Client 10.0
SQLNCLI11 Enumerator SQL Server Native Client 11.0 Enumerator
SQLNCLI10 Enumerator SQL Server Native Client 10.0 Enumerator
Windows Search Data Source Microsoft OLE DB Provider for Search
SSISOLEDB OLE DB Provider for SQL Server Integration Services
MSDASQL Microsoft OLE DB Provider for ODBC Drivers
MSDASQL Enumerator Microsoft OLE DB Enumerator for ODBC Drivers
MSOLAP Microsoft OLE DB Provider for Analysis Services 14.0
MSOLAP Microsoft OLE DB Provider for Analysis Services 14.0
Microsoft.Jet.OLEDB.4.0 Microsoft Jet 4.0 OLE DB Provider
SQLOLEDB Enumerator Microsoft OLE DB Enumerator for SQL Server
MSDAOSP Microsoft OLE DB Simple Provider
MSDAORA Microsoft OLE DB Provider for Oracle
MSOLAP Microsoft OLE DB Provider for Analysis Services 13.0
MSOLAP Microsoft OLE DB Provider for Analysis Services 13.0
Som du ser, ingen ACE.OLEDB driver i 32-bit, så måske du skulle prøve, at lade din applikation kun køre 64-bit.