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.

Microsoft APIs and frameworks

Graphics	Desktop Window Manager Direct2D Direct3D D3D (extensions) GDI / GDI+ WPF Silverlight WinRT XAML Windows Color System Windows Image Acquisition Windows Imaging Component DirectX Graphics Infrastructure (DXGI) Windows Advanced Rasterization Platform WinG

Audio	DirectMusic DirectSound DirectX plugin XACT Speech API XAudio2

Multimedia	DirectX Media Objects Video Acceleration Xinput DirectInput DirectShow Image Mastering API Managed DirectX Media Foundation XNA Windows Media Video for Windows

Web	MSHTML RSS Platform JScript VBScript BHO XDR SideBar Gadgets TypeScript

Data access	Data Access Components (MDAC) ADO ADO.NET ODBC OLE DB Extensible Storage Engine Entity Framework Sync Framework Jet Engine MSXML OPC

Networking	Winsock LSP Winsock Kernel Filtering Platform NDIS Windows Rally BITS P2P API MSMQ MS MPI DirectPlay

Communication	Messaging API Telephony API WCF

Administration and management	Win32 console Windows Script Host WMI (extensions) PowerShell Task Scheduler Offline Files Shadow Copy Windows Installer Error Reporting Event Log Common Log File System

Component model	COM COM+ ActiveX Distributed Component Object Model .NET Framework

Libraries	Framework Class Library Microsoft Foundation Classes (MFC) Active Template Library (ATL) Windows Template Library (WTL)

Device drivers	WDM WDF KMDF UMDF WDDM NDIS UAA BDA VxD

Security	Crypto API CAPICOM Windows CardSpace Data Protection API Security Support Provider Interface (SSPI)

.NET	ASP.NET ADO.NET Remoting Silverlight TPL WCF WCS WPF WF

Software factories	EFx Factory Enterprise Library Composite UI CCF CSF

IPC	MSRPC Dynamic Data Exchange (DDE) Remoting WCF

Accessibility	Active Accessibility UI Automation

Text and multilingual support	DirectWrite Text Services Framework Text Object Model Input method editor Language Interface Pack Multilingual User Interface Uniscribe

This article is issued from Wikipedia - version of the 2/24/2015. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.