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 PBSYC125.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 PBASE125.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.
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 PBSYJ125.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.
