.NET Framework Data Provider for OLE DB

This .NET Framework Wrapper Class Library is provided by Microsoft. The main functionality of the wrapper class library is contained in the file System.Data.dll.

Add a reference to the assembly System.Data and include the System.Data.OleDb namespace. Instantiate a new OleDbConnection connection object. Set the connection string and open the connection.

VB.NET code sample
Imports System.Data.OleDb
Dim myConnection As OleDbConnection = New OleDbConnection()
myConnection.ConnectionString = myConnectionString
' execute queries, etc
C# code sample
using System.Data.OleDb;
OleDbConnection myConnection = new OleDbConnection();
myConnection.ConnectionString = myConnectionString;
// execute queries, etc


The .NET Framework Data Provider for OLE DB uses native OLE DB through COM interop to enable data access. The OleDbConnection wraps/bridges to the underlying data provider specified in the connection string using the keyword "Provider". This means that virtually every OLE DB provider can be used through this class library. The .NET Framework Data Provider for OLE DB supports both local and distributed transactions. For distributed transactions, the .NET Framework Data Provider for OLE DB, by default, automatically enlists in a transaction.

More info about this wrapper class library can be found at the Microsoft product page.


There is no '.NET Framework Data Provider for OLE DB' installation package to download. (if you know about an installation package URL you can contribute to the community by submitting the info to us through this message form)

Connection Strings

The .NET Framework Data Provider for OLE DB wrapper class library can be used to connect to the following data sources by using the following connection string references:

SQL ServerSQL Server 2019SQL Server 2017SQL Server 2016SQL Server 2014SQL Server 2012SQL Server 2008SQL Server 2005SQL Server 2000SQL Server 7.0SQL Server CompactOracleIBM DB2MySQLSybase AdaptiveInformixPostgreSQLUniVerseUniDataAS/400ParadoxPervasiveNetezza DBMSInterbaseSQLBaseTeradataDBMakerExcelExcel 97Excel 2000Excel 2002Excel 2003Excel 2007Excel 2010Excel 2013TextfileAccessAccess 97Access 2000Access 2002Access 2003Access 2007Access 2010Access 2013Visual FoxProDBF / FoxProAzure SQL DatabaseOLAP, Analysis ServicesSharePointMS ProjectActive DirectoryExchangeIndex ServerHTML TableSybase Advantage


.NET Framework Data Provider for SQL Server Microsoft SqlClient Data Provider for SQL Server CData ADO.NET Provider for Excel Microsoft OLE DB Driver for SQL Server Microsoft ODBC Driver 17 for SQL Server Microsoft ACE OLEDB 12.0 Microsoft Jet OLE DB 4.0 .NET Framework Data Provider for ODBC MySQL Connector/Net Microsoft ODBC Driver 13 for SQL Server SQL Server Native Client 10.0 OLE DB Provider SQL Server Native Client 10.0 ODBC Driver Microsoft ODBC Driver 11 for SQL Server SQL Server Native Client 11.0 OLE DB Provider SQL Server Native Client 11.0 ODBC Driver ASE ADO.NET Data Provider SQL Native Client 9.0 OLE DB Provider SQL Native Client 9.0 ODBC Driver CData ADO.NET Provider for SharePoint Microsoft Access ODBC Driver Microsoft Access accdb ODBC Driver Microsoft OLE DB Provider for SQL Server Advantage .NET Data Provider .NET xlReader for Microsoft Excel Oracle Data Provider for .NET / ODP.NET .NET Compact Framework Data Provider for SQL Server Mobile Oracle Provider for OLE DB .NET Framework Data Provider for Oracle MySQL Connector/ODBC 5.1 IBPhoenix Open Source ODBC Driver (aka Firebird ODBC driver) SQLXML 4.0 OLEDB Provider Microsoft SQL Server ODBC Driver Microsoft.SQLSERVER.MOBILE.OLEDB.3.0 MySQL Connector/ODBC 5.2 Advantage ODBC Driver Npgsql IBM i Access ODBC driver Microsoft Excel ODBC Driver Microsoft Excel 2007 ODBC Driver DB2 .NET Data Provider MySQL Connector/ODBC 3.51 Advantage OLE DB Provider Sybase ASE OLE DB Provider Microsoft OLE DB Provider for OLAP U2.Net Adaptive Server Enterprise ODBC driver ADOMD.NET PostgreSQL ODBC Driver (psqlODBC) SIBPROvider Interbase OLE DB Provider SQLBase .NET Data Provider VFP OLE DB Provider SQLBase ODBC Adaptive Server Anywhere ODBC Driver Camelot .NET Connector for Microsoft SharePoint Context Connection MSDataShape Microsoft ODBC for Oracle IBM DB2 Driver for ODBC and CLI MyODBC 2.50 Pervasive OLE DB Provider Oracle in OraClient11g_home1 SQLXML 3.0 OLEDB Provider Microsoft OLE DB Provider for Oracle Microsoft OLEDB provider for DB2 Adaptive Server Anywhere OLE DB Provider Sybase SQL Anywhere (former Watcom SQL) ODBC driver IBM Informix OLE DB Provider PostgreSQL OLE DB Provider Microsoft Paradox Driver IBM Client Access OLE DB provider IBM Client Access ODBC driver IBM iSeries Access ODBC driver Easysoft ODBC Intersolv InterBase ODBC Driver Pervasive PSQL ADO.NET Data Provider Microsoft Text ODBC Driver Microsoft Visual FoxPro ODBC Driver Microsoft dBASE ODBC Driver Active Directory OLE DB provider OLE DB Provider for Index Server UniOLEDB UniObjects for .NET CData ODBC Driver for SharePoint 2015 CData ODBC Driver for Exchange 2015 Microsoft.SQLSERVER.CE.OLEDB.3.5 Oracle in OraHome92 Oracle in XEClient Microsoft ODBC Driver for Oracle dotConnect for Oracle IBM OLE DB Provider for DB2 MySQL OLEDB eInfoDesigns.dbProvider SevenObjects MySqlClient dotConnect for MySQL (former MyDirect.NET and Core Labs MySQLDirect.NET) MySQLDriverCS Intersolv 3.60 Intersolv 3.10 IBM Informix .NET Provider IBM Informix ODBC Driver Informix-CLI 2.5 Luxena dbExpress driver for Informix Pro dotConnect for PostgreSQL (former Core Labs PostgreSQLDirect) Intersolv 3.11 ODBC Driver IBM DB2 for i .NET data provider Pervasive ODBC Client Interface SQLBase OLE DB Data Provider Teradata .Net driver OLE DB Provider for Teradata Teradata ODBC Driver DBMaker 4.3 OLE DB Provider DBMaker ODBC Driver NetezzaSQL ODBC Driver Microsoft Project 2003 OLE DB Microsoft Project 2002 OLE DB Microsoft Project 2000 OLE DB Exchange OLE DB provider ExDAV Netezza OLE DB IBM UniVerse ODBC Driver DBMaker 5.2 OLE DB Provider .NET txtReader for Text Files