RDA失败，跪求高手！解决思路
RDA失败，跪求高手！！！！
我是用VS2005开发Pocket PC2003的应用程序,但用RDA进行数据库同步,但老是失败,提示下面的错误:
Number: 80072EFF
Description: A request to send data to the computer running IIS has failed. For more information, see HRESULT. [,,,,,]
NativeError: 28037
Source: Microsoft SQL Server 2000 Windows CE Edition
我是用SQL Server CE2.0把SQL Server2000上的数据库(名为pacs,内有patient和report两个表)数据拉到本地数据库(名为PocketPACS.sdf)上,IIS的虚拟目录sqlce的权限是”Anonymous access”,并且在客户端和服务器端的IE地址栏上输入”http://tsmcserver/sqlce/sscesa20.dll”也都能成功显示” SQL Server CE Server Agent”,但服务器上的表就是下载不到客户端,老是提示上面的错误,调了好几天,网上查了不少,但就是不成功,快疯了!!!!!!!!!!!
具体程序如下:
public string strDBFile = @ "My Documents\PocketPACS.sdf ";
public string strConnLocal = "Data Source= " + @ "My Documents\PocketPACS.sdf ";
public string strConnRemote = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Integrated Security=SSPI;User ID = TSMCSERVER//IUSR_TSMC-5YPPGHKTLD;Initial Catalog=pacs;Data Source=PocketPACS.sdf; ";
public string strURL = "http://192.168.1.104/sqlce/sscesa20.dll ";
private void menuLogin_Click_1(object sender, System.EventArgs e)
{
doctorsearch = new DoctorSearch();
if((textBox1.Text== "tsmc ")&&(textBox2.Text== "tsmc "))
{
doctorsearch.Show();
Cursor.Current = Cursors.WaitCursor;
if(File.Exists(strDBFile))
{
File.Delete(strDBFile);
}
SqlCeEngine dbEngine = new SqlCeEngine();
dbEngine.LocalConnectionString = strConnLocal;
try
{
dbEngine.CreateDatabase();
}
catch(SqlCeException exSQL)
{
MessageBox.Show( "Unable to create database " + exSQL.Errors[0].Message);
}
SqlCeRemoteDataAccess rdaNW = new SqlCeRemoteDataAccess();
try
{
rdaNW.LocalConnectionString = strConnLocal;
rdaNW.InternetUrl = strURL;
rdaNW.InternetLogin = " ";
rdaNW.InternetProxyPassword = " ";
rdaNW.Pull( "patient ", "SELECT * FROM patient ",strConnRemote,RdaTrackOption.TrackingOnWithIndexes, "ErrorDoctor ";
}
catch(SqlCeException exSQL)
{
Errors.ShowErrors(exSQL);
}
finally
{
rdaNW.Dispose();
}
Cursor.Current = Cursors.Default;
}
else
MessageBox.Show( "Wrong infromation.Please check it again ");
}
请教各位大侠,问题出在哪里?
------解决方案--------------------
打了SP3补丁的数据都是有密码的
------解决方案--------------------
这种场合更本就不合适采用RDA, 你的基本功还欠缺!
我是用VS2005开发Pocket PC2003的应用程序,但用RDA进行数据库同步,但老是失败,提示下面的错误:
Number: 80072EFF
Description: A request to send data to the computer running IIS has failed. For more information, see HRESULT. [,,,,,]
NativeError: 28037
Source: Microsoft SQL Server 2000 Windows CE Edition
我是用SQL Server CE2.0把SQL Server2000上的数据库(名为pacs,内有patient和report两个表)数据拉到本地数据库(名为PocketPACS.sdf)上,IIS的虚拟目录sqlce的权限是”Anonymous access”,并且在客户端和服务器端的IE地址栏上输入”http://tsmcserver/sqlce/sscesa20.dll”也都能成功显示” SQL Server CE Server Agent”,但服务器上的表就是下载不到客户端,老是提示上面的错误,调了好几天,网上查了不少,但就是不成功,快疯了!!!!!!!!!!!
具体程序如下:
public string strDBFile = @ "My Documents\PocketPACS.sdf ";
public string strConnLocal = "Data Source= " + @ "My Documents\PocketPACS.sdf ";
public string strConnRemote = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Integrated Security=SSPI;User ID = TSMCSERVER//IUSR_TSMC-5YPPGHKTLD;Initial Catalog=pacs;Data Source=PocketPACS.sdf; ";
public string strURL = "http://192.168.1.104/sqlce/sscesa20.dll ";
private void menuLogin_Click_1(object sender, System.EventArgs e)
{
doctorsearch = new DoctorSearch();
if((textBox1.Text== "tsmc ")&&(textBox2.Text== "tsmc "))
{
doctorsearch.Show();
Cursor.Current = Cursors.WaitCursor;
if(File.Exists(strDBFile))
{
File.Delete(strDBFile);
}
SqlCeEngine dbEngine = new SqlCeEngine();
dbEngine.LocalConnectionString = strConnLocal;
try
{
dbEngine.CreateDatabase();
}
catch(SqlCeException exSQL)
{
MessageBox.Show( "Unable to create database " + exSQL.Errors[0].Message);
}
SqlCeRemoteDataAccess rdaNW = new SqlCeRemoteDataAccess();
try
{
rdaNW.LocalConnectionString = strConnLocal;
rdaNW.InternetUrl = strURL;
rdaNW.InternetLogin = " ";
rdaNW.InternetProxyPassword = " ";
rdaNW.Pull( "patient ", "SELECT * FROM patient ",strConnRemote,RdaTrackOption.TrackingOnWithIndexes, "ErrorDoctor ";
}
catch(SqlCeException exSQL)
{
Errors.ShowErrors(exSQL);
}
finally
{
rdaNW.Dispose();
}
Cursor.Current = Cursors.Default;
}
else
MessageBox.Show( "Wrong infromation.Please check it again ");
}
请教各位大侠,问题出在哪里?
------解决方案--------------------
打了SP3补丁的数据都是有密码的
------解决方案--------------------
这种场合更本就不合适采用RDA, 你的基本功还欠缺!