For jConnect to function properly, you must install stored procedures and tables on the Adaptive Server Enterprise or Adaptive Server Anywhere database to which your application will be connecting. jConnect provides the following scripts to install the required stored procedures and tables:
sql_server.sql installs stored procedures on Adaptive Server Enterprise versions 11.9.2 and earlier.
sql_server12.sql installs stored procedures on Adaptive Server Enterprise version 12.0.
sql_server12.5.sql installs stored procedures on Adaptive Server Enterprise versions 12.5.x.
sql_asa.sql installs stored procedures on SQL Anywhere and Adaptive Server Anywhere databases.
Running stored-procedure installation scripts
Make sure that your JAVA_HOME, JDBC_HOME, and CLASSPATH environment variables are set.
To connect to a SQL Anywhere database earlier than version 6.0, start an Open Server Gateway.
Use the IsqlApp sample application according to the instructions in the following sections, based on the target database and your platform.
