Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database administration » SQL Anywhere graphical administration tools » Interactive SQL

 

Opening multiple Interactive SQL windows

You can open multiple Interactive SQL windows, each of which corresponds to a separate database connection. You can connect simultaneously to two (or more) different databases on different database servers, or you can open concurrent connections to a single database.

Prerequisites

There are no prerequisites for this task.

 Task
  1. In Interactive SQL, click Window » New Window.

    Tip

    If the SQLCONNECT environment variable is set, or if you are already connected to a SQL Anywhere database, the database server attempts to use this information to connect to a database before it prompts you for information. Likewise, if the ULSQLCONNECT environment variable is set, or if you are already connected to an UltraLite database, the database server attempts to use this information to connect to a database before it prompts you for information in. If these attempts fail, or if you are not already connected to a database, the Connect window appears.

  2. In the Connect window, enter the connection information for your database, and click Connect.

    You can also connect to or disconnect from a database by clicking SQL » Connect or SQL » Disconnect.

Results

The connection information (including the database name, your user ID, and the database server name) appears in the Interactive SQL title bar.

 See also