Configuration differences between ODP.NET, Managed Driver and ODP.NET, Unmanaged Driver

Table 2-10 lists other configuration differences between ODP.NET, Managed Driver and ODP.NET, Unmanaged Driver.

Table 2-10 Configuration Differences between ODP.NET, Unmanaged Driver and ODP.NET, Managed Driver

Feature Category Difference compared to ODP.NET, Unmanaged Driver

Configuration

The older, traditional ODP.NET, Unmanaged Driver configuration file format is different. The new format allows both providers to share the same format. See "Oracle Data Provider for .NET, Managed Driver Configuration."

Configuration

ConfigSchema.xsd file, shipped with ODP.NET, Managed Driver (when included as part of the schema (XML->Schemas) in Visual Studio) enables app.config intelli-sense.

Configuration

Windows Registry based configuration is not supported

Configuration

Oracle High Availability (HA) & Oracle RAC Load Balancing (RLB) notifications use Oracle Notification Service (ONS). Thus, to use HA or RLB, configure database and client to use ONS, rather than Oracle Database Advanced Queuing (AQ). Note that Continuous Query Notification will continue to use AQ.

Configuration Parameter

Edition is not supported.

Configuration Parameter

CheckConStatus is not supported.

Configuration Parameter

DllPath is not supported.

Configuration Parameter

SatementCacheWithUdts is not supported.

Configuration Parameter

ThreadPoolMaxSize is not supported.

Configuration Parameter

TraceFileName is not supported.

Configuration Parameter

UdtCacheSize is not supported.

Configuration Parameter

UDT Mapping is not supported.

Configuration Parameter

UseManagedDTC is supported by ODP.NET, Managed Driver only.

Configuration Parameter

UseOraMTSManaged is not supported.

Connection String

Context Connection is not supported.

Connection String

LegacyTransactionBindingBehavior setting will be ignored. It will always be set to the default value of 1.

Connection String

Promotable Transaction setting will be ignored. It will always be set to promotable and always support promotions.

Connection String

Statement Cache Purge is not supported.

Connectivity

Connection to Oracle Times Ten Database is not supported.

Performance Monitor

NumberOfStatisConnections performance counter is not supported.

Performance Monitor

Performance monitor category name is "ODP.NET, Managed Driver"

Provider Types

Provider Types accept (via constructors) and generate (via ToString() methods) only culture-invariant strings

Tracing

Dynamic tracing is enabled by changing the TraceLevel setting in the app/web/machine.config. NOTE: For ASP.NET applications, doing so will recycle the application domain.