Thursday, September 11, 2014

How to configure Oracle.ManagedDataAccess.Client.without installing on server

1.    Download ODAC121012Xcopy_x64 from Oracle Site

2.    Add the following file to project References and set properties to ‘Copy tolocal’ - True.
3.    Oracle.ManagedDataAccess.dll
4.    Add the following section to the beginning of your application's web.config (if you already have a configSections element, add the section to it:
name=" Oracle.ManagedDataAccess.Client "
    type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=, Culture=neutral, PublicKeyToken=89b483f429c47342" />

5.    Add the following sections to the end of your application's web.config:
     invariant="Oracle.ManagedDataAccess.Client" />
     name="ODP.NET, Managed Driver"
         description="Oracle Data Provider for .NET, Managed Driver"
         type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=, Culture=neutral, PublicKeyToken=89b483f429c47342" />
       name="TNS_ADMIN" value="C:\"/>
         name="bool" precision="1"/>
         name="byte" precision="2" />
         name="int16" precision="5" />

No comments: