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.
Select the Settings button to configure the Adaptive Server connection information. The Setting dialog box consists of these panels:
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.
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
Selects the amount of information to display on the Connect menu.
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
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
connect to Adaptive Server, click Details to view additional fields
and check the SSL box before you connect.
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 “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
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 to Adaptive Server
Cancel the connection attempt.
Display the online help for DBISQL.