How To Configure An ODP.NET Enabled Web Application Using Your Web.Config File

(Doc ID 834861.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Data Provider for .NET - Version 11.1.0.6.20 and later
Information in this document applies to any platform.
**Checked for relevance on 29-Jun-2017**

Goal

While running multiple ODP.NET enabled applications on the same machine you may want to configure each application with a different set of configuration settings.  In ODP.NET 11g and later there are multiple locations that can be used to specify an application's configuration settings.  The following list shows their order of precedence:

  1. registry (machine-wide for a particular version of ODP.NET)
  2. machine.config (.NET Framework-wide, there are different machine.config files for different .NET Framework versions)
  3. app.config / web.config
  4. connection string

The higher the number the higher the precedence of these configuration settings should they be specified.  For example, setting tracing parameters in the web.config would override setting them in the registry.

The information below will show you how to configure web application settings that would turn on tracing using your web.config file under .NET Framework 1.x and 2.x.

NOTE: You must be using ODP.NET 11g or later in order to use this feature.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms