Microsoft ODBC for Oracle

This ODBC Driver is provided by Microsoft. The main functionality of the driver is contained in the file MSORCL32.DLL.

Include "Driver={Microsoft ODBC for Oracle}" in the connection string to use this driver.

Description

The Microsoft Oracle ODBC Driver comes with the Microsoft Data Access Components (MDAC). There is no other distributable that contains this driver.

  Download and install the latest MDAC package.

Download

This ODBC Driver, Microsoft ODBC for Oracle, can be downloaded here.

Connection Strings

The Microsoft ODBC for Oracle driver can be used to connect to the following data sources by using the following connection string references:

Oracle

Providers

Oracle Data Provider for .NET / ODP.NET Oracle Provider for OLE DB .NET Framework Data Provider for Oracle Oracle in OraClient11g_home1 Microsoft OLE DB Provider for Oracle .NET Framework Data Provider for OLE DB MSDataShape Oracle in OraHome92 Oracle in XEClient Microsoft ODBC Driver for Oracle .NET Framework Data Provider for ODBC dotConnect for Oracle

Articles

read all »
Download Oracle 11g Release 2 Client ODBC Drivers How to Access Oracle from BI Tools: Tableau, Power BI, DBxtra Formating Rules for Connection Strings Connection Strings Explained Store Connection String in Web.config Connection Pooling The Provider Keyword, ProgID, Versioning and COM CLSID Explained Store and read connection string in appsettings.json SQL Server Data Types Reference Network Protocol for SQL Server Connection