To access a Sybase server through the sql.ini file, each server must be included in the sql.ini file on the client computer.
Adding a server entry to the interfaces file
on your PC-Client computer
From Windows, select Start | Programs | Sybase | Connectivity | Open Client Directory Service Editor.
Click OK on the first window to open the Interfaces Driver window.
Select Server Object from the menu, and click Add.
In the Input Server Name box, enter the name of the server for which you are creating an entry.
Click OK.
In the Attributes column, double-click the server address row you just added.
In the Protocol Network Address, click Add.
In the Network Address box, you can enter either the server name or the IP address, along with the server port number. For example:
machine_name, 4100
Where:
machine_name – is the name of the computer
4100 – is the port number the server is using to “listen” for clients
Windows accepts TCP-style connection information:
[SERVER] MASTER=NLWNSCK,huey,2222 QUERY=NLWNSCK,huey,2222
or
[SERVER] MASTER=TCP,heuy,2222 QUERY=TCP,heuy,2222
The preferred format is to use TCP and a space between the host_name and port_number, because it is supported across all platforms. You can edit the interfaces file with any standard ASCII text editor.
To find the IP address for a machine, use ypmatch on a UNIX box, ipconfig on Windows.
You can use Windows Directory Replication to replicate sql.ini in multiple
locations. See the Microsoft documentation for information. You
can also use directory services, which are stored in the Registry.
For additional information on using dsedit on the client computer, see the Open Client and Server Configuration Guide for Desktop Platforms and the Open Client and Server Supplement.