Settings in ECDA

Use the following settings in the ECDA configuration file:

Transaction Mode = long
allocate = connect
SQL transformation = Sybase

When set batch is “on,” you must also specify:

DelimitSqlRequests = yes

If you have a tinyint datatype at the replicate table, the following parameter must be added to the Datatype Conversion section of the Microsoft SQL service in ECDA Microsoft SQL Server.

TinyIntResults=tinyint