系统环境: win7旗舰版,iis版本为7.5,vs2005,wince6.0,SQL Server CE 3.5
实现步骤:
一:在电脑端安装IIS,特别注意勾选"ISAPI 扩展",不然"Microsoft SQL Server Compact Server Agent"是无法开启的.
二:在电脑端安装SSCEDeviceRuntime-CHS.msi及SSCEServerTools-CHS-x86.msi
三:在电脑端配置web向导,请参考 http://wenku.baidu.com/view/3a3c712cb4daa58da0114a27.html ,配置完成后,在浏览器打开 http://服务器地址/虚拟目录/sqlcesa35.dll,如果能看到"Microsoft SQL Server Compact Server Agent",表示配置成功.
四:编写代码
//建库
SqlCeConnection conn = null;
if (File.Exists(@"Temp/Test.sdf"))
{
MessageBox.Show("exists");
File.Delete(@"Temp/Test.sdf");
}
SqlCeEngine engine = new SqlCeEngine(@"Data Source = Temp/Test.sdf");
engine.CreateDatabase();
conn = new SqlCeConnection(@"DataSource = Temp/Test.sdf");
conn.Open();
if (conn.State == ConnectionState.Open)
conn.Close();
//pc 到pda 的数据库同步
string rdaOleDbConnectString = "Provider=sqloledb; Data Source='localhost';Initial Catalog=jxc2010_v9;User Id=sa;Password =cdth426";//这是pc 上的sqlserver2000 下的
SqlCeRemoteDataAccess rda = null;
rda = new SqlCeRemoteDataAccess();
rda.InternetLogin = "IUSR";
rda.InternetPassword = "";
rda.InternetUrl = @"http://192.168.1.101/sqlce/sqlcesa35.dll";
rda.LocalConnectionString = @"Data Source=/Temp/Test.sdf";//这是pda(wince)上的
rda.Pull("AAA001", "SELECT *FROM AAA001", rdaOleDbConnectString,
RdaTrackOption.TrackingOn, "ErrorTable");
//上面这一句是同步就是把pc上的表拷贝到pda上如果pda上有同名的表就会出错
MessageBox.Show("1");
rda.Dispose();