关于SQLCE2.0和SQL 2000之间RDA的问题,急!!!!
我的IDE是Visual studio 2005,在上面开发PPC2003的程序,远端数据库选用的是SQL 2000,IIS和SQL在同一机器上,SQL2.0已经配置,在PPC和PC的IE上面都可以访问到http://192.168.1.50/sqlce/sscesa20.dll,但是使用RDA的时候,显示传输信息中的HTTP标头信息以坏或缺失。。(代码是28035)
具体代码如下:
scRda = new SqlCeRemoteDataAccess("http://192.168.1.50/sqlce/sscesa20.dll",String.Empty,String.Empty,@"Data Source=\Program Files\Issue_Vision\localdb.sdf");
scRda.InternetLogin = "akira";
scRda.InternetLogin = "akira";
scRda.InternetUrl = "http://192.168.1.50/sqlce/sscesa20.dll";
scRda.LocalConnectionString = @"Data Source=\Program Files\Issue_Vision\localdb.sdf";
string remoteconnect = "User ID=sa;Password=sa;data source=\"COMPUTER\\SQL2000" +
"\";persist security info=False;initial catalog=LoginInfo";
scRda.Pull("lstaff", "SELECT staff_id,staff_name,passwd FROM staff", remoteconnect, RdaTrackOption.TrackingOnWithIndexes);
IIS采用匿名访问。请问如何解决上面产生的问题?很可能是那些地方出错呢?谢谢!