A server class must be assigned to each server when it is added using sp_addserver. Server classes determine the access method used to interact with the remote server. The server classes are:
ASEnterprise – used if the server is Adaptive Server. This is the default server class.
ASAnywhere – used if the server is Adaptive Server Anywhere version 6.0 or later. This server class should be used for Adaptive Server IQ versions earlier than Adaptive Server IQ 12.5.
ASIQ – used if the server is Adaptive Server IQ version 12.5.
local – the local server. There can be only one.
direct_connect – indicates that the server is an Open Server™ application that conforms to the interface requirements of a DirectConnect™ server. For access to Microsoft SQL Server, you must use a DirectConnect server.
db2 – indicates that the server is a gateway to DB2 or DB2-compatible databases. This class is provided only for backward compatibility. The preferred class is direct_connect.
sds – indicates that the server conforms to the interface requirements of a Specialty Data Store.
