ADORelease database parameter
Description
Specifies the version of the ADO.NET data provider that is
in use on the client workstation.
When to specify ADORelease
You must specify a value for ADORelease before connecting
to the database.
Controls
-
ADO.NET
Syntax
|
1 |
ADORelease='<span>value</span>' |
|
Parameter |
Description |
|---|---|
|
value |
Specifies the version of an ADO.NET data For Sybase Adaptive Server® Enterprise, the optional
For Oracle, the optional values are:
|
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
To specify that your PowerBuilder application accesses
an Adaptive Server 15 database using the ASE ADO.NET Data Provider:
-
Database profile
Select 1.1.50.0 from the ADORelease drop-down list on the
Connection page in the Database Profile Setup dialog box. -
Application
Type the following in code:
1SQLCA.DbParameter="ADORelease='1.15.50.0'"