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