EAServer uses a slightly different version of the Sybase Open Client CT-Library (CT-Lib) software from PowerBuilder. Therefore, at runtime, you need to use SYJ rather than ASE or SYC to connect to an 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 EAServer), you must use ASE or SYC to connect to the database.
Note that the SYJ database interface supports only those DBParms relevant at runtime. It does not support any DBParm parameters that have to be set before PowerBuilder establishes a database connection. The following DBParms, which are included on the SYJ Profile Setup dialog box, are not supported by SYJ:
All the DBParms on the Regional Settings tab including CharSet, Language, and Locale
All the Directory services DBParms on the Directory Services tab
All the Security services DBParms on the Security tab
All the DBParms on the Network tab including AppName, Host, MaxConnect, PacketSize, and PWEncrypt
The Release DBParm on the Connection tab
The TableCriteria DBParm on the System tab
The Asynchronous Operations DBParms, Async and DBGetTime, on the Transaction tab
