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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » Connecting to a database » Connecting from Sybase Central, Interactive SQL, or the SQL Anywhere Console utility

 

Working with the Connect window

The Connect window lets you define parameters for connecting to a server or database from Sybase Central, Interactive SQL, or the SQL Anywhere Console utility. The information entered in the Connect window is not preserved between sessions.

The Connect window has the following tabs:

  • The Identification tab lets you identify yourself to the database and specify a data source.
  • The Database tab lets you identify a server and/or database to connect to.
  • The Advanced tab lets you add additional connection parameters and specify a driver for the connection.

The Connect window has a Connect Assistant to help you connect to a database. To display or hide the Connect Assistant, click the arrow in the top right corner of the window.

The Connect window showing the Connect Assistant

The Connect window also has a Tools button that contains the following tools:

  • The Test Connection tool tests your connection before exiting the Connect window.
  • The Copy Connection String To Clipboard tool creates a connection string from the options you specified in the Connect window and copies the string into your clipboard.
  • The Save As ODBC Data Source tool lets you quickly create an ODBC data source from the specified options.

After you connect successfully in Sybase Central, the database name appears in the left pane of the main window, under the server that it is running on. The user ID for the connection appears after the database name.

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