Configuring Adaptive Server for ECDA Option for Oracle

Define the remote server to Adaptive Server before using ECDA Option for Oracle and Adaptive Server to access remote data.

Use sp_addserver to define the service, server class, and network access information for ECDA Option for Oracle, and to add an entry for each service. The server class is direct_connect.

Parameters to sp_addserver are:

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 ECDA Option for Oracle server is direct_connect.
network_name – the name in the interfaces file associated with this server. The network_name parameter defaults to the server_name.

For example:

sp_addserver ORACLEDC, direct_connect, ORACLEDC

Next

For more information on configuring Adaptive Server, refer to Adaptive Server/CIS documentation.