sqlite和sqlserver2005同步有关问题

sqlite和sqlserver2005同步问题
客户端使用的数据库是sqlite,服务端使用的数据库是Microsoft SQL Server 2005，同步的时候出现下面错误：
无法获取新的服务器定位点。请确保能够建立与服务器数据库的连接，并确保指定的 DbServerSyncProvider 的 SelectNewAnchorCommand 属性是正确的。
sqlserver2005中orders表结构如下：
order_id（pk,int,not null),
order_date(nvarchar(50),null)
LastEditDate(datetime,null)
CreationDate(datetime,null)
同步代码如下：

C# code

            SyncAgent SyncAgent = new SyncAgent();
            SqlConnection serverConnection = new SqlConnection(strSqlServer);
            DbServerSyncProvider syncServerSyncProvider = new DbServerSyncProvider();
            syncServerSyncProvider.Connection = serverConnection;

            SyncAgent.RemoteProvider = syncServerSyncProvider;            

            SqliteClientSyncProvider syncClientSyncProvider = new SqliteClientSyncProvider(strSqlite);           
            SyncAgent.LocalProvider = syncClientSyncProvider;           

            SyncTable tableOrders = new SyncTable("orders");
            tableOrders.CreationOption = TableCreationOption.DropExistingOrCreateNewTable;
            tableOrders.SyncDirection = SyncDirection.Bidirectional;

            SyncGroup orderGroup = new SyncGroup("AllChanges");
            tableOrders.SyncGroup = orderGroup;
            SyncAgent.Configuration.SyncTables.Add(tableOrders);

            SqlSyncAdapterBuilder ordersBuilder = new SqlSyncAdapterBuilder();
            ordersBuilder.Connection = serverConnection;
            ordersBuilder.SyncDirection = SyncDirection.Bidirectional;

            //db';Data Sou

跟踪调试直到 Microsoft.Synchronization.Data.SyncStatistics syncStats = SyncAgent.Synchronize();这一步才报错
确定服务器连接正确（在界面上取服务端orders表数据无误），很可能是DbServerSyncProvider 的 SelectNewAnchorCommand 属性，
试着调了许多次也没成功，请问，SelectNewAnchorCommand 属性是哪里设置错误了，先谢谢你们了

------解决方案--------------------
帮顶

sqlite和sqlserver2005同步有关问题

相关推荐