.NET Framework Data Provider for OLE DB

This .NET Framework Wrapper Class Library is provided by Microsoft.
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.
Download link missing
The .NET Framework Data Provider for OLE DB installation package download link is missing. Please provide info and contribute to the community by email to
Connection Strings
The .NET Framework Data Provider for OLE DB wrapper class library can be used to connect to the following data sources:

Access Access 2007 Active Directory AS/400 (IBM iSeries) DBF / FoxPro DBMaker Excel Excel 2007 Exchange HTML Table IBM DB2 Index Server Informix Interbase MS Project MySQL Netezza DBMS OLAP, Analysis Services Oracle Paradox Pervasive Postgre SQL SharePoint SQL Azure SQL Server 2000, 7.0 SQL Server 2005 SQL Server 2008 SQL Server 2012 SQL Server Compact SQLBase Sybase Adaptive Sybase Advantage Teradata Textfile UniData UniVerse Visual FoxPro / FoxPro 2.x
To see available connection options, navigate connection strings reference by the above data source links.
Additional info or comments on this wrapper class library? Want to submit content?


Copyright © 2013 30c.org   |   All Rights Reserved   |   Powered by CSAS   |   Send feedback, articles, requests and more connection strings here.