Making and modifying server entries

Server Entry Version

Integer

The version level of the server object definition.

Sybase provides this attribute to identify future changes to the object definition.

15001

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.

SQL Server

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

• DECnet (four formats)

  1. area_number.node_number,object_name 2. area_number.node_number,object_number 3. node_name,object_name 4. node_name,object_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