Search notes:

OLE DB provider

Some OLE DB providers

ProgId Description Comments
ADSDSOObject Microsoft OLE DB Provider for Microsoft Active Directory Service Read-only connections to heterogeneous directory services through ADSI
IBMDADB2 Advanced Page. IBM DB OLE DB Data Link Advanced Page (With CLSID = {00000000-0000-0000-0000-000000000000} ???)
Microsoft.Jet.OLEDB.4.0 Microsoft OLE DB Provider for Microsoft JET
Microsoft.ACE.OLEDB.12.0 Microsoft OLE DB Provider for Microsoft Access database engine
Microsoft.Mashup.OleDb Microsoft Power Query OLE DB provider This provider is specially suited for mashing-up data and found under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Classes\Microsoft.Mashup.OleDb.1. See also displaying the result of a Power Query program in an excel ListObject.
MSDAORA Microsoft OLE DB Provider for Oracle
MSDAIPP.DSO Microsoft OLE DB Provider for Internet Publishing Access resources (HTML pages, web folders) served by Microsoft FrontPage or Microsoft Internet Information Server
MSDAOSP Microsoft OLE DB Simple Provider used to access any data for which a provider has been written using the OLE DB Simple Provider (OSP) Toolkit.
MSIDXS Microsoft OLE DB Provider for Microsoft Indexing Service read-only, SQL based access to file system and Web data indexed by Microsoft Indexing Service.
MSDASQL Microsoft OLE DB Provider for ODBC Default provider for ADO
MSDASQL Enumerator Microsoft OLE DB Enumerator for ODBC Drivers
MSDataShape Microsoft Data Shaping Service for OLE DB Create hierarchical (shaped) Recordset objects from a data provider. Deprecated in favor of XML.
MSOLAP MSOLAP 11.0 OLE DB Provider Aka Microsoft OLE DB Provider for Analysis Services 13.0
MSPersist Microsoft OLE DB Persistence Provider provides the ability to save a recordset into a file (both the ADTG or XML format) and restore it later
MS Remote Microsoft OLE DB Remoting Provider This provider enables a local user on a client machine to invoke data providers on a remote machine. (RDS is deprecated in favor of WCF Data Sources)
OraOLEDB.Oracle Oracle Provider for OLE DB See also a list of Oracle provided files that implement this provider
Search.CollatorDSO Microsoft OLE DB Provider for Search Compare with Windows Search Data Source
SSISOLEDB OLE DB Provider for SQL Server Integration Services
SQLNCLI10 SQL Server Native Client 10.0
SQLNCLI11 SQL Server Native Client 11.0 Deprecated in favor of MSOLEDBSQL
SQLNCLI11 Enumerator SQL Server Native Client 11.0 Enumerator
SQLNCLI10 Enumerator SQL Server Native Client 10.0 Enumerator
SQLOLEDB Microsoft OLE DB Provider for SQL Server Deprecated in favor of MSOLEDBSQL
SQLOLEDB Enumerator Microsoft OLE DB Enumerator for SQL Server
Windows Search Data Source Microsoft OLE DB Provider for Search Comapre with Search.CollatorDSO

See also

Required registry entries for OLE DB providers
The registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\instance name\Providers stores the names of OLE DB Providers along with their settings that an SQL Server instance can access.
The .NET class System.Data.OleDb.OleDbEnumerator allows to enumerate OLE DB providers within the local network.
A PowerShell script that does that is found under finding OLE DB providers.
This example demonstrates how a CSV file can be imported into an Excel table with Visual Basic for Application and an OLE DB provider.

Index