ADORelease

Description

Specifies the version of the ADO.NET data provider that is in use on the client workstation.

Applies to

• ADO.NET

Syntax

ADORelease='value'

Default

1.1.411.0 for Adaptive Server, 9.2.0.401 for Oracle.

Usage

The ADORelease database parameter specifies the version of the ADO.NET database provider used for native connections to a database server using ADO.NET.

For Adaptive Server, specify Sybase.Data.AseClient as the Namespace in the Database Profile Setup dialog box for ADO.NET to display available versions of the Sybase ASE ADO.NET Data Provider in the Release drop-down list.

The database provider is supplied in the .NET assemblies Sybase.PowerBuilder.Db.dll (for Adaptive Server 12.5.x and Oracle9i) and Sybase.PowerBuilder.DbExt.dll (for Adaptive Server 15.x and Oracle 10g). You must deploy the appropriate version of this DLL with your application.

For Oracle, specify Oracle.DataAccessClient as the Namespace in the Database Profile Setup dialog box for ADO.NET to display available versions of the Oracle Data provider for .NET (ODP.NET) in the Release drop-down list.

When you select a driver version, the ADO.NET interface attempts to load that driver. If the driver is redirected to a higher version of the driver, the higher driver is loaded, but only the features in the selected driver may be supported. For example with Oracle ODP.NET, if ADORelease is set to 9.2.0.401 but the policy file on your computer redirects the driver to version 10.1.0.301, the ODP.NET 10.1.0.301 driver is loaded. New features in ODP.NET 10.1.0.301 are not supported.

Examples

Example 1

To specify that your PowerBuilder application accesses an Adaptive Server 15 database using the ASE ADO.NET Data Provider: