Connection shortcuts in Sybase Central  Creating connection profiles

Chapter 3: Sybase IQ Connections

Creating server objects

Sybase IQ provides a shortcut to connection information that you can use to:

To insert from an Adaptive Server Enterprise database to a Sybase IQ database, each server must have an entry, also called a server object, in the interfaces file. Use DSEDIT (Directory Services Editor) to create entries in the interfaces file. You must be the owner of the Sybase home directory (%SYBASE%) in order to run DSEDIT.

Once you add servers to this file, the Server Name dropdown box is enabled wherever Sybase Central requests connection information. When you tab to the dropdown box, pressing the space bar lists all the entries you created with DSEDIT. You can choose a server from the list or just press the first letter of the server name you want to use. Pressing the same letter multiple times cycles through all the values that begin with that letter.

NoteYou must use dbisql, not isql to access multiplex databases.

StepsAdding a server object

  1. Open the Utilities folder in Sybase Central and double-click Directory Services Editor.

    Shown is the select directory service window. The main part of the window shows a list of available data service names from which you can choose. On the right are two command buttons: OK and cancel. At the bottom is a text box containing the full path of the configuration file highlighted in the directory service name box

  2. Click OK.

  3. Select Server Object > Add from the menu bar.

  4. Type the server name. The server name in your DSEDIT entry must be the same as the database name. Click OK when finished.

  5. Select Server Address.

    Shown is the interfaces driver window. the left pane lists the server and path and the right pane lists attributes and values of the highlighted server

  6. Right-click on Server Address and select Modify Attribute.

  7. Click Add.

  8. Use the dropdown box to select the desired protocol. For example, TCP.

  9. In the Network Address box, type the hostname and port number, separated by a comma, for example:

    Shown is the input network address for protocol window. At left is a drop down box to select a protocol and at right is a text box to type the network address. The bottom of the window has two command buttons: OK and cancel

    You can substitute the network address for the hostname (for example, “157.133.75.47,1234”).

  10. Click OK.

  11. To test the server's availability right-click on any of the Attributes and select Ping Server.

  12. Click Ping to test the server.

  13. Click OK and Done when finished.

Object names allow all users at your installation to connect more quickly. They can simply click the Server Name dropdown to choose from all servers defined and supply their own usernames and passwords to connect.




Copyright © 2004. Sybase Inc. All rights reserved. Creating connection profiles

View this document as PDF