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>
0 comments