Connecting using Open Client

If you need to insert from an Adaptive Server Enterprise database to a Sybase IQ database, or you want to connect using ISQL, each server must have an entry in the interfaces file on the client computer. Interfaces file entries, also called server objects, also simplify database start-up. Use DSEDIT (Directory Services Editor) to create entries in the interfaces file. You must be the owner of the Sybase home directory (%SYBASE%) to run DSEDIT.

Adding server objects also simplifies connections to servers from Sybase Central.

1. Start Programs > Sybase > Open Client Directory Service Editor.

   

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.

5. Click OK.

6. Select Server Address.

   

7. Right-click Server Address and select Modify Attribute.

8. Click Add.

9. Use the drop-down box to select the desired protocol. For example, TCP.

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

    

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

11. Click OK.

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

13. Click Ping to test the server.

14. Click OK and Done when finished.