If you plan to use any of the products in PowerBuilder Enterprise with SQL Anywhere 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 SQL Anywhere or Adaptive Server Enterprise database that you want to prepare for jConnect.
To prepare a SQL Anywhere or Adaptive Server 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_SA.sql for SQL Anywhere, sql_server12.5.sql for Adaptive Server version 12.5 or later, sql_server12.sql for Adaptive Server version 12, or sql_server.sql for earlier versions of Adaptive Server.
Click the Execute button.
