New and Enhanced DB Interfaces
\The Sandbox \PB History & Future \New In PB7 \DB Interfaces
DBs Not
Supported

Description

PowerBuilder 7 offers three new database interfaces as well as enhancements to several existing interfaces. These new and enhanced interfaces expand both the number and type of databases with which your application can interact:

Database interface

Functionality

New Sybase SYJ database interface

Provides connectivity to Sybase Adaptive Server Enterprise 11.5 for a PowerBuilder custom class user object deployed as a Jaguar component

Using the SYJ interface  Sybase's Jaguar CTS uses a slightly different version of the CT-Lib software. Therefore, at runtime, you need to use the SYJ database interface rather than SYC to connect to a Adaptive Server Enterprise database. The SYJ Database Profile Setup dialog box provides a convenient way to set the appropriate connection parameters and then copy the syntax from the Preview tab into the script for your Transaction object.

You cannot use the SYJ interface, however, to connect to the database in the PowerBuilder development environment. Therefore, during the development phase (before the component has been deployed to Jaguar), you must use SYC to connect to the database.

New JDS and JDM JDBC database interface

Provides connectivity to databases that comply with the JDBC API

New OLE DB database interface

Provides connectivity to databases that comply with the new OLE DB API. OLE DB provides an architecture for accessing all types of data — both SQL and non-SQL — by componentizing database and related data processing functionality

INTERSOLV OLE DB data providers are supplied with PowerBuilder

The initial release of the OLE DB interface will be supported on Windows only

Enhanced Sybase SYC database interface

Provides support for new functionality in Sybase Adaptive Server Enterprise 11.5 including the ability to create and use extended stored procedures as well as to create a DataWindow object based on a heterogeneous cross-database join

Enhanced Sybase DIR database interface

Provides support for a DirectConnect Transaction Router Service (TRS) connection to a DB2/MVS database

PowerBuilder 7 continues to support database interfaces for the latest versions of the Oracle, , INFORMIX, and Microsoft SQL Server database servers, including Oracle Version 8.0.4, INFORMIX Version 9.x, and Microsoft SQL Server Version 7.x.

PowerBuilder 7 also supports an updated ODBC driver to access Sybase's Adaptive Server Anywhere 6.0.

When using the PowerBuilder Professional and Desktop editions  All the database interfaces supported by PowerBuilder may not be available in the PowerBuilder Professional and Desktop editions.

For more information

Database interfaces no longer supported

PBL Peeper PB Help PB History
& Future About Us Feedback Site Map

Google
 
Web www.techno-kitten.com
www.sybase.com