MobiLink Synchronization User's Guide
Synchronization Basics
Consolidated database
Setting up a consolidated database
To set up Microsoft SQL Server to work as a MobiLink consolidated database, run the syncmss.sql setup script, located in the MobiLink\setup subdirectory of your SQL Anywhere installation.
You must set up an ODBC DSN for your Microsoft SQL Server consolidated database. Unlike the other consolidated databases, iAnywhere Solutions does not provide an ODBC driver for Microsoft SQL Server. This is because the Microsoft SQL Server driver is freely available for download.
However, there are two changes that you should make to the default configuration to use Microsoft SQL Server as a consolidated database. In the Microsoft SQL Server DSN Configuration dialog, remove the check marks from the following options:
Use ANSI quoted identifiers
Use ANSI nulls, paddings and warnings
For updated details, see http://www.ianywhere.com/developer/technotes/odbc_mobilink.html.