To use jConnect to access system table information (database metadata), you must add the jConnect system objects to your database.
You must have the ALTER DATABASE, BACKUP DATABASE, and SERVER OPERATOR system privileges, and must be the only connection to the database.
Back up your database files before upgrading. If you attempt to upgrade a database and it fails, then the database becomes unusable.
Context and remarks
jConnect system objects are installed into a SQL Anywhere database by default when you use the dbinit utility. Also, jConnect system objects are not required for Windows Mobile databases. 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.
Use the Sybase Central SQL Anywhere 16 plug-in to connect to the database.
Click Tools » SQL Anywhere 16 and then click Upgrade Database.
Follow the instructions in the Upgrade Database Wizard.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|