Making and modifying server entries

Once you open a session with a directory service or sql.ini, you can add, modify, rename, and delete server entries associated with that session.

The server entries associated with the session appear in the Server box. Click a server entry to select it.

Each server entry is made up of a set of attributes. The attributes and attribute values of a server entry, shown in Table 8-1, appear on the right side of the dialog box.

**Table 8-1: Server attributes**
Attribute name	Type of value	Description	Default value
Server Entry Version	Integer	The version level of the server object definition. Sybase provides this attribute to identify future changes to the object definition.	15501
Server Name	Character string	The server’s name.	N/A
Server Service	Character string	A description of the service provided by the server. This value can be any meaningful description.	ASE
Server Status	Integer	The operating status of the server. Valid values are: 1 – Active 2 – Stopped 3 – Failed 4 – Unknown	4
Server Address	Character string	One or more addresses for the server. The format of the address varies by protocol, and some protocols allow more than one format. The options are: TCP/IP (two formats) 1. computer_name,port_number 2. ip-address,port_number Named Pipe pipe_name: “\pipe” is a required prefix to all pipe names. Server pipes can only be local. (Local) \pipe\sql\query (Remote) \\computer_name\pipe\sql\query IPX/SPX (three formats) 1. server_name 2. net_number,node_number,socket_number 3. server_name, socket_number	N/A
Server HAfailover (optional)	Character string	The name of the High Availability Failover server, if configured.	N/A
Server Security (optional)	Character string	Object identifier strings (OID) that specify the security mechanisms supported by the server. This attribute is optional. If it is omitted, the Open Server allows clients to connect with any security mechanism for which the Open Server has a corresponding security driver. (See Server Library and security services for process details.) See objectid.dat for more information about object identifier strings.	N/A