Connecting to remote servers without the interfaces file

You can establish a connection to remote servers without using corresponding entries in directory services ldap or interfaces files. This is accomplished through Component Integration Services’s use of the CT-Library connection property CS_SERVERADDR, which allows a server to be specified in the form:

"hostname.domain.com:99999"
"hostname:99999"
"255.255.255.255:99999"

where 99999 is the port number, and hostname is expressed as a simple name, an IP address, or a complete domain name.

Enter names in this format using sp_addserver with the net name argument:

sp_addserver S1, ASEnterprise, "myhost.sybase.com:11222"

or:

sp_addserver S1, ASEnterprise, "192.123.321.101:11222"

There are some limitations to this usage of net names:

If this syntax is used, CT-Library does not attempt to look up connection information from directory services, whether an interfaces file or LDAP server is configured.

If SSL is configured and you have a pointer to the SSL section in the server docs, you can use the optional SSL syntax:

"hostname.domain.com:99999:SSL"
"hostname:99999:SSL"
"255.255.255.255.99999:SSL"

For more information about configuring Adaptive Server for SSL, see Chapter 19, “Confidentiality of Data,” in the System Administration Guide: Volume One.