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

Interactive SQL Online Help Interactive SQL Version 16.0 » Interactive SQL Help

Connecting to Adaptive Server

The Connect dialog allows you to find the servers and connect to them.

StepsConnecting to a server

  1. Enter your User ID and Password in the appropriate fields.

  2. Specify how you want to connect to the server. You can

    The server name dropdown list contains server names from your interfaces file, including servers you configured to use an LDAP server from your interfaces file and the LDAP server you configured.

    Lightweight Directory Access Protocol (LDAP) is an industry standard for accessing directory services. Directory services allow components to look up information by a distinguished name (DN) from an LDAP server that stores and manages server, user, and software information that is used throughout the enterprise or over a network.

    The LDAP server can be located on a different platform from the one on which Adaptive Server or the clients are running. LDAP defines the communication protocol and the contents of messages exchanged between clients and servers

  3. Select the server to which you want to connect and then click OK.

  4. Click OK in the Connect dialog box to connect to the server.

Additionally, the Connect menu includes the information described below.

Settings button

Select the Settings button to configure the Adaptive Server connection information. The Setting dialog box consists of these panels:

Find button

Click Find to discover additional servers on the network.These servers are monitored by Unified Agents that support the JINI (the default) and UDP protocols.

To configure the search for additional servers:

  1. Select Tools | Adaptive Server Enterprise | Preferences.

  2. Select the Server Discovery page.

  3. Select Add to add a new setting.

    Edit or remove existing settings using Edit and Remove buttons. The settings are used in the order they are listed. Rearrange the settings with the Up and Down buttons

Details button

Selects the amount of information to display on the Connect menu.

SSL checkbox

When the interfaces entry includes an SSL filter, DBISQL automatically checks the SSL check box (and disabled). DBISQL unchecks the checkbox when you enter an ad-hoc server name using the host:port format.

SSL (Secure Socket Layer) is the standard for securing the transmission of sensitive information.

The interfaces entry must contain an SSL filter if Adaptive Server is SSL-enabled. For example, if an Adaptive Server called HRDPT listens on port 6666 through SSL, the interfaces entry would look similar to:


If you use host name and port number "hrhost:6666" to connect to Adaptive Server, click Details to view additional fields and check the SSL box before you connect.

Advanced button

The Advanced tab of the Connect dialog allows you to enter additional connection parameters. Enter one connection parameter per line.


The following connection parameters set connection host name information to “” and limit the number of rows returned from the server to 50.



Select the tools button to:

Connect button

Connect to Adaptive Server

Cancel button

Cancel the connection attempt.


Display the online help for DBISQL.