Creating interfaces file entries

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 startup. 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.

The dsedit utility lets you view and edit server entries in the interfaces file using a GUI based on X11/Motif in UNIX platforms.

1. Start the Open Client Directory Service Editor.

   % $SYBASE/$SYBASE_OCS/bin/dsedit
   

2. The default interfaces file and configuration file display.

   Click OK to continue or Exit to quit.

3. Select “Add new server entry.”

4. Type the server name and click Add new network transport. The server name in your DSEDIT entry must be the same as the database name.

5. Select the TCP transport and enter the host name and port number. (The defaults are usually sufficient.) Click OK.

6. Click OK.

7. The server is now listed under “Available servers.”

8. Click Close session to make new server entries usable.

9. Click Exit to close dsedit.

10. Click Yes to “Are you sure you want to exit dsedit?”