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 11 and then Upgrade Database.

    The Upgrade Database Wizard appears.

  3. Follow the instructions in the wizard to add jConnect support to the database.

To add jConnect system objects to a database (dbupgrad)

  • From a command prompt, execute 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.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0