Network Communications Using sql.ini

Adaptive Server communicates with other Adaptive Servers, Open Server applications, and client software across a network. Clients can communicate with one or more servers, and servers can communicate with other servers via remote procedure calls. You can configure Adaptive Server to use sql.ini file connections.

Use Server Config to change the values that Adaptive Server can access.

Adaptive Server on Windows supports network connections using the Named Pipes, Sockets (TCP/IP), and IPX/SPX protocols. The default Adaptive Server uses TCP/IP and Named Pipes, since Named Pipes is always installed with Windows.

These files, which reside on both server and client machines, enable each Sybase product to find the other Sybase servers that are on the network. The installation program automatically creates, verifies, and appends these configuration files when you install Adaptive Server.

• Client Connections to Adaptive Server
  Client software connects to Adaptive Server by looking at the sql.ini file and the libtcl.cfg file and loading the specified Net-Library driver.
• Determine the Address to Listen for Client Connections
  Adaptive Server uses the sql.ini file to determine the address at which to listen for clients.
• Client Access to Adaptive Server
  The Adaptive Server installation program provides a default sql.ini file, which has MASTER and QUERY entries that use both the Named Pipes and Sockets (TCP/IP) drivers for all installed servers.
• Components in the sql.ini File
  The sql.ini file includes the server name, network driver, service type, and server address. Understanding these components is useful background information for editing an sql.ini file.
• Share Network Configuration Information
  You can share identical network information across multiple systems by either creating a master interface (sql.ini) file or by using Windows Registry as a directory service.
• Verify Server Connections
  After you configure your network connections, use the dsedit utility to verify that you can connect to a server. dsedit includes a network diagnostic utility that checks to see whether a process is listening at the specified address.
• Configure ODBC Connections
  Some client applications do not connect to Adaptive Server directly through the Open Client software, but through the ODBC (Open Database Connectivity) driver instead.
• IPv6 Support
  Adaptive Server supports IPv6 technology.