ADORelease – PB Docs 2019

Description

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

Applies to

ADO.NET

Syntax

Default value

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 SAP 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

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