Modifying server entries in Windows NT

The server entries associated with the session appear in the Server box (see Figure 4-1). Click on a server entry to select it.

Each server entry is made up of a set of attributes. The attributes are described in Table 4-1.

**Table 4-1: 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.	110
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.	Adaptive 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

To add a server entry

Choose Server Object | Add.
Type a server name in the Server Name box.
Click OK.

The server entry appears in the Server box. To specify an address for the server, you must modify the entry.

To modify a server attribute

You can modify any attribute of a server entry.

Click on a server entry in the Server box.
Choose Server Object | Modify Attribute.
Click on the attribute you want to modify in the Attributes box.

A dialog box appears that shows the current value of the attribute.
Type a new value for the attribute, or select a value from the drop-down list.

See Table 4-1 for a description of each attribute.
Click OK.

To rename a server entry

Click on a server entry in the Server box.
Choose Server Object | Rename.
Type a new name for the server entry in the Server Name box.
Click OK.

To delete a server entry

Click on a server entry in the Server box.
Choose Server Object | Delete.

To copy server entries within the current session

Click on one or more server entries in the Server box.

Use the Shift key to select multiple entries.
Click the Copy button (below the menu bar), or choose Edit | Copy.
Click the Paste button (below the menu bar), or choose Edit | Paste.

dsedit appends the copied server entries with a version number of _n. You can rename the copied server entries Server Object | Rename option on. See “To rename a server entry” for more information.

To copy server entries between sessions

Open a session with the directory service or sql.ini file that you want the entries copied to.
To open a session, choose File | Open Directory Service. See “To open additional sessions” for more information.
Click on one or more server entries in the Server box of the session that you want the entries copied from.

Use the Shift key to select multiple entries.
To copy the server entries, click the Copy button (below the menu bar), or choose Edit | Copy.

To cut the server entries, click the Cut button (below the menu bar), or choose Edit | Cut.
Activate the session where you want to paste the server entries.

See “To switch between sessions” for instructions for activating a session.
Click the Paste button (below the menu bar), or choose Edit | Paste.

You can rename the copied server entries using Server Object | Rename. See “To switch between sessions” for more information.