Add, View, and Edit Server Entries

Once you are in an open session, you can add, modify, rename, and delete server entries associated with that session, as well as copy server entries within a session and between sessions.

Each server entry is made up of a set of attributes.

Server attributes

Attribute name

Type of value

Description

Default value

Server Version

Integer

Version level of the server object definition. Sybase provides this attribute to identify future changes to the object definition.

150

Server Name

Character string

Server name.

N/A

Server Service

Character string

A description of the service provided by the server. This value can be any meaningful description.

The SAP ASE server

Server Status

Integer

The operating status of the server. Values are:
  • Active

  • Stopped

  • Failed

  • Unknown

4

Security Mechanism

Character string

Object identifier strings (OID) that specify the security mechanisms supported by the server. This attribute is optional. If it is omitted, Open Server allows clients to connect with any security mechanism for which Open Server has a corresponding security driver.

N/A

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:

    • computer name,port number

    • ip-address,portnumber

  • Named Pipe – pipe name: “\pipe” is a required prefix to all pipe names. Server pipes can be only local.

    • Local\pipe\sql\query

    • Remote\\computer_name\pipe\sql\query

  • IPX/SPX – three formats:

    • server name

    • net number, node number, socket number

    • server name, socket number

  • DECnet – four formats:

    • area number.node number,object name

    • area number.node number,object number

    • node name,object name

    • node name,object number

N/A