Integrating a Standalone SQL Anywhere Database with WorkSpace

If you are using a standalone SQL Anywhere 10 database, integrate it with WorkSpace to access its data.

  1. Open the Database Development perspective.
  2. Verify that the SQL Anywhere instance is running and that the connection profile to the database server is connected.
  3. Click the Execute Multiple SQL Files icon, located on the main toolbar for the perspective. Execute multiple XML files icon
  4. Select asa_10.sql, navigating to it if needed. The asa_10.sql file is located at <your_WorkSpace_dir>\DevRuntimes\ASA\.
  5. In the Select Profile for the Files dialog, select the following and click OK:
    1. Sybase_ASA_10.x for the database server type.
    2. The connection profile used to connect to the database server instance.
  6. Use the SQL Results view to verify that the sql file execution was successful.
  7. Restart SQL Anywhere.

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.