Use the system stored procedure sp_addserver to define the service, server class, and network access information for DirectConnect for Oracle. The server class is direct_connect. Use sp_addserver to add an entry for each service.
Parameters to sp_addserver are defined as follows:
server_name – the name of the server as it is known to Adaptive Server in the sysservers table.
server_class – the class to use when defining a DirectConnect for Oracle server is direct_connect.
network_name – the value of this parameter represents the name in the interfaces file associated with this server. The network_name parameter defaults to the server_name.
See the following example:
sp_addserver ORACLEDC, direct_connect, ORACLEDC
