If you plan to use any of the products in PowerBuilder Enterprise with ASA or Adaptive Server Enterprise databases, including databases that were previously prepared for jConnect™ for JDBC™ 4.x, you need to prepare the databases for jConnect 5.5 by installing additional tables and stored procedures. You must repeat the following steps for every ASA or Adaptive Server Enterprise database that you want to prepare for jConnect.
To prepare an ASA or Adaptive Server Enterprise
database for jConnect 5.5:
Start Interactive SQL and connect to your database.
Select File>Open and locate the appropriate SQL file stored in the jConnect-5_5\sp folder.
jConnect is installed in the Sybase\Shared folder. Use sql_asa.sql for ASA, sql_server12.5.sql for Adaptive Server Enterprise version 12.5, sql_server12.sql for Adaptive Server Enterprise version 12, or sql_server.sql for earlier versions of Adaptive Server Enterprise.
Click the Execute button.
