Replication Server provides several scripts that can help you set up a connection from the target database to Replication Server using an access service that is configured with the following settings:
TransactionMode = long
ReturnNativeError = yes
SQLTransformation = sybase
Allocate = connect
For more information, see:
Replication Server Administration Guide, specifically Chapter 6, “Managing Database Connections,” and Chapter 12, “Customizing Database Operations.”
Replication Server Heterogeneous Replication Guide, Chapter 4, “Data Server Issues.”