Supported versions for Adaptive Server
You can access Adaptive Server versions 11.x, 12.x, and 15.x
using the SYC Adaptive Server database interface. Use
of this interface to access other Open Server™ programs
is not supported. The SYC database interface uses a DLL named PBSYC126.DLL to
access the database through the Open Client™ CT-Lib API.
You can also access Adaptive Server version 15.x using the
ASE Adaptive Server database interface. Use
of this interface to access other Open Server programs is not supported.
The Adaptive Server database interface uses a DLL named PBASE126.DLL to
access the database through the Open Client CT-Lib API. To use this
interface, the Adaptive Server 15 client must be installed on the
client computer. The ASE interface supports large identifiers with
up to 128 characters.
Client Library API
The Adaptive Server database interfaces use the Open Client
CT-Library (CT–Lib) application programming interface (API)
to access the database.
When you connect to an Adaptive Server database, PowerBuilder makes
the required calls to the API. Therefore, you do not need to know
anything about CT-Lib to use the database interface.
When deploying a PowerBuilder custom class user
object in EAServer
EAServer uses a slightly
different version of the CT-Lib software. Therefore, at runtime
you need to use the SYJ database interface rather than ASE or SYC to
connect to an Adaptive Server 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. The SYJ database
interface uses a DLL named PBSYJ126.DLL.
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 EAServer), you must use ASE
or SYC to connect to the database.