Oracle Data Providers and Connection Strings

When accessing Oracle from MM .NET, the Framework uses Oracle's ODP.NET Provider.

ODP.NET features optimized data access to Oracle. It allows developers to take advantage of advanced Oracle functionality such as Real Application Clusters, Multiple Active Result Sets (MARS), a native XML data type, XML DB, the ability to bind array parameters, flexible LOB tuning, and advanced security. This provider can be used with Oracle 9 release 2 or higher.

When using the Oracle .NET Data Provider from Microsoft, you use **mmDataAccessOracle** to access data from your Oracle database.

Your application configuration settings would look something like this:

<add key="Northwind\Connection" value="User Id=SCOTT;Password=tiger;Data Source=Northwind"/>
<add key="Northwind\DataAccessClass" value="DataAccessOracle"/>

Go to this link to download ODP.NET:

http://www.oracle.com/technetwork/topics/dotnet/index-085163.html