Replicate Database Connectivity for Microsoft SQL Server

A Replication Server database connection name is made up of two parts: a data server name (server_name) and a database name (db_name).

The server_name is the name of the ECDA for ODBC database gateway server, and the db_name is the name of the Microsoft SQL Server replicate database.

The replicate Replication Server looks for an interfaces file entry for the database gateway server_name specified in the Replication Server database connection. The replicate Replication Server logs in to the replicate data server using the user_name and password specified in the database connection.

Make an entry in the Replication Server interfaces file to identify the host and port where the ECDA Option for ODBC database gateway server is listening. The interfaces file entry name must match the server_name portion of the Replication Server database connection.