Microsoft OLE DB Provider for Oracle

This OLE DB Provider is provided by Microsoft. The main functionality of the provider is contained in the file msdaora.dll.

Include "Provider=msdaora" in the connection string to use this provider.

Description

The Microsoft OLE DB Provider for Oracle allows distributed queries on data in Oracle databases.

Download

There is no 'Microsoft OLE DB Provider for Oracle' 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 Microsoft OLE DB Provider for Oracle provider 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 Microsoft ODBC for Oracle Oracle in OraClient11g_home1 .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