.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
myConnection.Open()
' execute queries, etc
myConnection.Close()

C# code sample

using System.Data.OleDb;
OleDbConnection myConnection = new OleDbConnection();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
// execute queries, etc
myConnection.Close();

Description

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.

Download

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