Client/Server Communication

Adaptive Server communicates with other Adaptive Servers, Open Server applications (such as Backup Server), and client software on your network. Clients can interact with one or more servers, and servers can communicate with other servers by remote procedure calls.

For Sybase products to interact with one another, a directory services file must list the names and addresses of every known server. This information can be stored in either:

After your Adaptive Server or client software is installed, it can connect with any server on the network that is listed in the interfaces file or in the LDAP server.

When you are using a client program, and you want to connect with a particular server, the client program looks up the server name in the interfaces file and connects to that server. You can supply the name of the server by using the DSQUERY environment variable.

On TCP/IP networks, the port number gives clients a way to identify the Adaptive Server to which they want to connect. It also tells Adaptive Server where to listen for incoming connection attempts from clients. Adaptive Server uses a single port for these two services (referred to as listener service query service).

On SPX networks, the socket number gives clients and servers a way to identify each other.

Communicating with a Server Using the sql.ini File
Image shows the system administrator connecting to Adaptive Server through the sql.ini file

The installer adds entries to the sql.ini file for the new Adaptive Server, Backup Server, or XP Server.

Note: You can use Windows File Replication to replicate sql.ini in the multiple locations. See the Microsoft documentation for information. You can also use Windows Registry to keep the interfaces file information.