Address Format

The format of the server address depends on the network driver used by SAP ASE.

The format for the server address can be:

Use these guidelines to define your server address:

Some formats require a port, or socket number. Port numbers for MASTER and QUERY entries must be the same on server and client. For example, if a server is listening on 5000, the client workstation must be connecting on 5000.
The server usually controls the port number, which means that you specify the same port number in the client’s sql.ini file as that specified in the sql.ini file for the server to which it is connecting.
Port addresses must be unique to each server. The port address is determined by the port number provided in the sql.ini file, and the IP address.
By default, the port number for SAP ASE is 5000; for Backup Server, it is 5001.

Note: Two SAP ASEs on different computers can use the same port number because their IP addresses are different.