Developers community number 1 connection string reference

.NET Framework Data Provider for OLE DB

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

Coding

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.

Connection Strings

The .NET Framework Data Provider for OLE DB wrapper class library can be used to connect to the following data sources.

To see the available connection options, navigate to the connection strings reference by clicking the data source link.