Working with Server Entries

Use dscp to add or modify server entries.

Note: When you add or modify a server entry, dscp automatically creates or modifies both master and query lines. The master line and the query line of an interfaces file entry contain identical information.

After you open a session, you can add or modify server entries associated with that session.

Each server entry is made up of a set of attributes. When you add or modify a server entry, dscp prompts you for information about each attribute.

Server attributes
Attributes	Type of value	Default value and valid values	Can be edited when adding or modifying a server entry
Attributes	Type of value	Default value and valid values	Adding	Modifying
Server Object Version	Integer	110	No	No
Server Name	Character string	N/A	N/A	No
Server Service	Character string	SQL SERVER	Yes	No
Server Status	Integer	4 Valid values are: Active Stopped Failed Unknown	No	No
Transport Type	Character string	tcp. Valid values are: decnet, spx, tcp, tli, spx, tli tcp Note: Adaptive Server does not support the TLI interface in threaded mode.	Yes	Yes
Transport Address	Character string	None. Valid values are character strings recognized by the specified transport type	Yes	Yes
Security Mechanism	Character string Note: You can add up to 20 security mechanism strings for each server entry	None Valid values are character strings associated with object identifiers defined in the user’s objectid.dat.	Yes	Yes