当前位置: 代码迷 >> 其他数据库 >> sqlite和sqlserver2005同步有关问题
  详细解决方案

sqlite和sqlserver2005同步有关问题

热度:9359   发布时间:2013-02-26 00:00:00.0
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 属性是哪里设置错误了,先谢谢你们了

------解决方案--------------------------------------------------------
帮顶
  相关解决方案