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=4.112.3.50, 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"
         invariant="Oracle.ManagedDataAccess.Client"
         description="Oracle Data Provider for .NET, Managed Driver"
         type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.112.3.50, Culture=neutral, PublicKeyToken=89b483f429c47342" />
  
 
<Oracle.ManagedDataAccess.Client>
   number="*">
    
      
      
       name="TNS_ADMIN" value="C:\"/>
    
    
       dataType="number">
         name="bool" precision="1"/>
         name="byte" precision="2" />
         name="int16" precision="5" />
      
    
  
</Oracle.ManagedDataAccess.Client>


No comments: