RDA数据同步错误

muranscanf 2009-10-11 04:10:25

错误信息：
未处理 System.Data.SqlServerCe.SqlCeException
Message=""
HResult=-2147024891
NativeError=0
代码
string dbPathName = @"\rda.sdf";
if (File.Exists(dbPathName))
File.Delete(dbPathName);
string strCon = "Data Source =" + dbPathName + ";Password=";
SqlCeEngine engine = new SqlCeEngine(strCon);
engine.CreateDatabase();
engine.Dispose();
SqlCeRemoteDataAccess rda = null;
//SQL Server 所在的主机的IP
string remoteIP = "172.16.108.61";
//SQL Server 中的数据库,名为ABC
string remoteDB = "netcf";
// 数据库ABC 的用户和密码
string user = "sa";
string pwd = "123456";
// 本地sqlce 数据库的路径和名字, 该数据库存在于win CE 系统下.
string localDB = dbPathName;
// 本地sqlce 数据库密码
string localPwd = "";
// 要同步的数据表名
string table = "person";
// 用于连接SQL Server 数据库的字符串
string rdaOleDbConnectString = @"Provider=sqloledb;Data Source=172.16.108.61;Initial Catalog=netcf;Persist Security Info=True;User ID=sa;Password=123456";
//string rdaOleDbConnectString = "Data Source=ITEE-PSC;Initial Catalog=netcf;Integrated Security=ITEE-PSC;";
// 连接本地sqlce 数据库的字符串, 作为SqlCeRemoteDataAccess对象的一个参数
string localConnectString = @"Data Source=" + localDB;
rda = new SqlCeRemoteDataAccess();
//rda.InternetLogin = "IUSR_ITEE-PSC";
rda.InternetLogin = "";
rda.InternetPassword = "";
rda.InternetUrl = "http://ITEE-PSC/sqlce3/sqlcesa30.dll";
rda.LocalConnectionString = localConnectString;
// 执行同步,SQL SERVER 同步到sqlce
// 参数RdaTrackOption.TrackingOn 指示SQL ServerMobile 跟踪对所提取表的所有更改。
rda.Pull(table, "SELECT * FROM " +table, rdaOleDbConnectString, RdaTrackOption.TrackingOff,"EEER");

...全文