In general, Open Client applications (such as isql) require an interfaces file to identify available servers, host machines, and client ports. On Windows, the interfaces file is named sql.ini; on UNIX, 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 other Open Server application, you must create a server entry for the Replication Agent in the interfaces file on the Open Client application host machine.
A server 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 protocol used for the connection.
host_name is the name of the Replication Agent host machine.
port_num is the client socket port number of the administration port.
For example, to specify an interfaces file entry for a Replication Agent instance named “my_ra,” using the Windows socket protocol, on a host named “my_host,” with client socket port number 10002, you would add the following lines to the interfaces file:
[my_ra] query=NLWNSCK,my_host,10002
Some systems require the interfaces file to be in the TLI form. If your system does, you must use a utility (such as sybtli or dsedit) that edits the interfaces file and saves the result in a form compatible with TLI.
After you create an entry for the Replication Agent instance in the interfaces file, you can connect to the administration port using any Open Client application that uses that interfaces file.
