Oracle ODP.NET Data Provider
This version of the Enterprise Library Oracle Data Provider was tested against the Oracle Database 10g Express Edition (XE)
and the ODP.NET 11g client from Oracle v11.1.0.7.10 downloaded separately. To use both on the same PC you will need to install the Microsoft Loopback Adapter.
Note: The installation order is significant. Install Oracle XE first and then the updated ODP.NET client second.
Oracle XE can be downloaded from
http://www.oracle.com/technology/products/database/xe/index.html and is licence free.
The installation includes the server components and the older 10g ODP.NET provider. Newer providers are downloaded separately for interim upgrades.
ODP.NET can be downloaded from
http://www.oracle.com/technology/tech/windows/odpnet/index.htmlOnce this is installed you will need to copy the TNSNAMES.ORA and SQLNET.ORA files from your Oracle XE 10g server home Network\Admin folder over
to your new 11g client home Network/Admin folder and install the Microsoft Loopback Adapter if you are running everything from the same PC.
Note: Oracle XE typically installs its server home folder into C:\oraclexe\app\oracle\product\10.2.0\server.
The following is an example of a configuration file using an Oracle ODP.NET Data Provider:
[XML]
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
<section name="oracleConnectionSettings" type="EntLibContrib.Data.OdpNet.Configuration.OracleConnectionSettings, EntLibContrib.Data.OdpNet" />
</configSections>
<dataConfiguration defaultDatabase="Service_Dflt">
<providerMappings>
<add databaseType="EntLibContrib.Data.OdpNet.OracleDatabase, EntLibContrib.Data.OdpNet, Version=4.1.0.0, Culture=neutral, PublicKeyToken=null" name="Oracle.DataAccess.Client" />
</providerMappings>
</dataConfiguration>
<oracleConnectionSettings>
<add name="OracleTest">
<packages>
<add name="PKGNORTHWIND" prefix="NWND_" />
<add name="PKGENTLIB" prefix="RegionSelect" />
</packages>
</add>
</oracleConnectionSettings>
<connectionStrings>
<add name="Service_Dflt"
providerName="Oracle.DataAccess.Client"
connectionString="Data Source=XE;User id=Northwind;Password=Northwind;" />
<add name="NewDatabase"
providerName="Oracle.DataAccess.Client"
connectionString="Data Source=XE;User id=Northwind;Password=Northwind;" />
<add name="DbWithOracleAuthn"
providerName="Oracle.DataAccess.Client"
connectionString="Data Source=XE;User id=Northwind;Password=Northwind"/>
<add name="NwindPersistFalse"
providerName="Oracle.DataAccess.Client"
connectionString="Data Source=XE;User id=Northwind;Password=Northwind;Persist Security Info=false"/>
</connectionStrings>
</configuration>