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.

The sql.ini file looks similar to:

[PIANO_XP]
master=NLWNSCK,PIANO,5002
query=NLWNSCK,PIANO,5002


[PIANO]
master=NLWNSCK,PIANO,5000
query=NLWNSCK,PIANO,5000


[PIANO_BS]
master=NLWNSCK,PIANO,5001
query=NLWNSCK,PIANO,5001


[PIANO_JSAGENT]
master=NLWNSCK,PIANO,4900
query=NLWNSCK,PIANO,4900


[ws]
master=NLWNSCK,PIANO,8183

• Server Name
  The server name is the SAP ASE to which clients connect.
• Network Driver
  The network driver specifies the name of the Net-Library driver to use for the connection. The driver name must correspond to a valid entry in the library (libtcl.cfg) file, which is located in the ini subdirectory of the SAP installation directory.
• Service Type
  The service type defines the SAP ASE service as either MASTER or QUERY.
• Server Address
  The server address is the address at which SAP ASE listens for client connections.