In general, Open Client applications (such as isql) require an interfaces file to identify available servers, their host machines, and their client ports. On Windows NT and Windows 2000 operating systems, the interfaces file is named sql.ini. On UNIX operating systems, the interfaces file is named interfaces.
If you want Open Client applications to be able to connect to the Replication Agent administration port, as they would to any Open Server application, you must create an entry for the Replication Agent administration port in the interfaces file.
An entry for a Replication Agent administration port in an interfaces file appears as follows:
[inst_name] query=Protocol,Host_Name,Port_Num
where inst_name is the name of the Replication Agent instance, Protocol is the network socket protocol used to connect with the Replication Agent administration port, Host_Name is the name of the Replication Agent host machine, and Port_Num is the client socket port number specified for the administration port when the Replication Agent instance was created.
For example, to specify an interfaces file entry for a Replication Agent instance named “NY2_RA” using the Microsoft Windows NT sockets protocol on a host named “NYHost3” with the client socket port number 10002, you would add the following lines to the interfaces file:
[NY2_RA] query=NLWNSCK,NYHost3,10002
Some systems require the interfaces file to be in the TLI form. If your system requires that, you must use a utility that edits the interfaces file and saves the result in a form compatible with TLI, such as sybtli or dsEdit.
After you create an entry in the interfaces file for the Replication Agent instance, you can connect to the administration port using any Open Client application that uses the interfaces file.
