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