OleDbConnectionUse an OLE DB provider from .NET

Provider=any oledb provider's name;OledbKey1=someValue;OledbKey2=someValue;

See the respective OLEDB provider's connection strings options. The .net OleDbConnection will just pass on the connection string to the specified OLEDB provider. Read more here.

Connecting

This connection string (Use an OLE DB provider from .NET using OleDbConnection) can be used for connections to Access 2000, Access 2002, Access 2003, Access 2007, Access 2010, Access 2013, Access 97, Active Directory, AS/400, DBF / FoxPro, DBMaker, Excel 2000, Excel 2002, Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 97, Exchange, HTML Table, IBM DB2, Index Server, Informix, Interbase, MS Project, MySQL, Netezza DBMS, OLAP, Analysis Services, Oracle, Paradox, Pervasive, PostgreSQL, SharePoint, SQL Azure, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 7.0, SQL Server Compact, SQLBase, Sybase Adaptive, Sybase Advantage, Teradata, Textfile, UniData, UniVerse and Visual FoxPro.

Articlesread all »

Not the right connection string for you?

Start over in the connection string reference index.

You can also get help in the Q&A forums where you can ask your own question.

The kb articles contains how-tos and instructions and you can search for anything if you're not sure were to look.