OLE DB provider

An OLE DB provider is a software component enabling an OLE DB consumer to interact with a data source. OLE DB providers are analogous to ODBC drivers, JDBC drivers, and ADO.NET data providers.

OLE DB providers can be created to access such simple data stores as a text file and spreadsheet, through to such complex databases as Oracle, Microsoft SQL Server, Sybase ASE, and many others. It can also provide access to hierarchical data stores such as email systems.

However, because different data store technologies can have different capabilities, every OLE DB provider cannot implement every possible interface available in the OLE DB standard. The capabilities that are available are implemented through the use of COM objects; an OLE DB provider will map the data store technologies functionality to a particular COM interface. Microsoft describes the availability of an interface as "provider-specific," as it may not be applicable depending on the data store technology involved. Note also that providers may augment the capabilities of a data store; these capabilities are known as services in Microsoft parlance.

OLE DB providers

• OLE DB Providers Tested with SQL Server
• Microsoft ships a few OLE DB Providers as part of its MDAC and JET kits
• Simba Technologies ships SimbaProvider, an SDK used to build custom OLE DB for OLAP providers for multi-dimensional and star schema database connectivity.
• OpenLink Software ships components supporting OLE DB access to a number of data sources, including several SQL DBMS, as well as Bridges to ODBC- and JDBC-accessible data sources
• OLE DB Provider for Interbase and Firebird (supports 14 database types, free and pro versions are available)
• OLE DB Provider for PostgreSQL

External links

• "OLE DB Providers Overview". Microsoft. MSDN: Data Developer Center. Retrieved 23 March 2011.