The Connect Dialog

The Connect dialog lets you define parameters for connecting to a server or database.

The Connect dialog 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 Network tab lets you specify either the shared memory or TCP/IP connection protocol, choose a security option, and specify encryption parameters.

  • The Advanced Options tab lets you add connection parameters and specify a driver for the connection.

After you connect, the database name appears in the left pane of the main window, under the name of the server where it runs. The user ID for the connection appears in brackets after the database name.

After you connect in Interactive SQL, the connection information, including the database name, your user ID, and the database server, appears on a title bar above the SQL Statements pane.