Installing jConnect system objects into a database

If you want to use jConnect to access system table information (database metadata), you must add the jConnect system objects to your database.

You can add the jConnect system objects to the database when creating the database or at a later time by upgrading the database. You can upgrade a database from Sybase Central or by using the dbupgrad utility.

Windows Mobile

Do not add jConnect system objects to your Windows Mobile database. See Using jConnect on Windows Mobile.

Caution

You should always back up your database files before upgrading. If you apply the upgrade to the existing files, then these files become unusable if the upgrade fails. For information about backing up your database, see Backup and data recovery.

 To add jConnect system objects to a database (Sybase Central)
  1. Connect to the database from Sybase Central as a DBA user.

  2. Select the database, if necessary, and then from the Tools menu choose SQL Anywhere 12 and then Upgrade Database.

  3. Follow the instructions in the Upgrade Database Wizard.

 To add jConnect system objects to a database (dbupgrad)
  • From a command prompt, run the following command:

    dbupgrad -c "connection-string"

    In this command, connection-string is a suitable connection string that enables access to a database and server as a DBA user.