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.
ADO.NET
ADORelease='value'
Parameter |
Description |
---|---|
value |
Specifies the version of an ADO.NET data provider your application uses. For Sybase Adaptive Server® Enterprise, the optional values are:
For Oracle, the optional values are:
|
1.1.411.0 for Adaptive Server, 9.2.0.401 for Oracle.
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.
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:
SQLCA.DBParm="ADORelease='1.15.50.0'"