Connecting to Adaptive Server

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

Connecting to a server

Enter your User ID and Password in the appropriate fields.
Specify how you want to connect to the server. You can
- Select a server from the server name dropdown list.
- Enter the host name and port number separated by a colon.
- (Optional) enter the character set and language you want to use to connect to this server by entering the values in the Character set and Language fields.
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
Select the server to which you want to connect and then click OK.
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:

General panel:
- Remember N recently connected servers – number of server connection profiles retained by DBISQL.
- Clear servers – clears the number of server connection profiles.
- Connect to last used database – connect to the database you most recently used.
- Set login timeout to N seconds – configures the amount of time the connection waits before timing out.
- Use default interfaces file – indicates you are using the default interfaces file. To use a nondefault interfaces file, deselect the check box and enter the path to the interfaces file.
LDAP panel – DBISQL lists the available LDAP servers.
- ASE entries can be retrieved from an LDAP server – lists the available LDAP servers. Select the LDAP server to which you want to connect and then Ok
- Retrieve ASE entries from LDAP – enables or disables DBISQL from finding LDAP servers.
- LDAP server search timeout – configures the amount of time DBISQL searches for LDAP servers. Set the scrollbar to the appropriate number.
Server Discovery. DBISQL lists:
- Enable server discovery – enables or disables the server discovery feature.
- The Server Discovery Filter dialog box includes these buttons:
  - Add – add a new filter
  - Remove – remove a listed filter
  - Edit – edit a listed filter
  - Up – moves a protocol up the list
  - Down – moves a protocol down the list
  Selecting the Add or Edit button displays the Add Discovery Setting screen, which includes:
  - Discovery method – the method DBISQL uses to discover the available servers. Jini or UDP
  - Discovery host – the host on which the server runs. Enabled when you select the JINI discovery method. Use the default or specify a host name.
  - Discovery port – the port number to which you connect DBISQL. Enabled when you select the JINI discovery method. Use the default or specify a port number.
- Filters – limit the scope of your server discovery search so that only certain Adaptive Servers that match a set of rules are displayed. For example, you can create a filter to show only Adaptive Servers built in the last 12 months.
  
  The Plug-in shows what filters are enabled on the Server Discovery tab. To add or edit a filter, click the Filters button. The Plug-in displays the Server Discovery Filters dialog box, which lists the current filters. You can enable or disable filters, but Server Discovery only uses the enabled filters for its search. The Server Discovery Filter dialog box includes these buttons:
  - Add – Add a new filter
  - Remove – Remove a listed filter
  - Edit – Edit a listed filter
  - Enable All – Enable all listed filters
  - Disable All – Disable all listed filters
  Filters are comprised of a Target (a server attribute) and a Condition (a search condition). To add a new filter:
  - Click Add. The Plug-in displays the Add Filter dialog box.
  - If you want this filter enabled, select Enable this filter.
  - Select the target you want filtered from this list (the Name target shows by default. The available targets are: Host, Name, OS, Platform, Port, Release type, Status, Version.
  - Select the condition you want filtered from the list (the “does not contain” condition shows by default). This available conditions are: contains, does not contain, is, is not, starts with, ends with.
  - Enter the condition string you want filtered.
  - Select OK to configure this filter.

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:

Select Tools | Adaptive Server Enterprise | Preferences.
Select the Server Discovery page.
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:

[HRDPT]
master=TCP,hrhost,6666,ssl
query=TCP,hrhost,6666,ssl

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.

name=value

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

SQLINITSTRING=SET ROWCOUNT 50
HOSTNAME=my_host.sybase.com

Tools

Select the tools button to:

Test Connection – tests the connection based on the hostname and port number you entered without connecting to the server.
Copy connectin string to clipboard – copies the complete connection information.

Connect button

Connect to Adaptive Server

Cancel button

Cancel the connection attempt.

Help

Display the online help for DBISQL.