本文介绍了RDA拉出错误:无法设置非参数化查询,可能是不正确的SQL查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

问候,
我正在尝试使用C#创建一个移动应用程序,在该应用程序中,SQL SERVER表的数据被拉并推"到PPC并再次返回.
我正在使用.NET 2005,SQL SERVER 2005和SQL SERVER2005CE.

另外,在以下代码中:

字符串sqlServerConnection = @"Provider = SQLOLEDB;数据源
=''192.χ.χ.χ'';初始目录= Hospital_RDA;用户ID = sa;密码= 123;
SqlCeRemoteDataAccess myRDA =新的SqlCeRemoteDataAccess("http://192.x.x.x/Hospital_PatientRDA/sqlcesa30.dll","DataSource = \\ Program Files \\ pullmethod \\ PullRDA.sdf");
myRDA.LocalConnectionString =数据源= \\程序文件\\拉法\\\ PullRDA.sdf";
字符串strDoctorEmployeeNo = txtDoctorEmployeeNo.Text;
字符串strCmd ="SELECT * FROM Patient WHERE DoctorEmployeeNo =""+ strDoctorEmployeeNo;
myRDA.Pull("Patient",strCmd,sqlServerConnection,RdaTrackOption.TrackingOffWithIndexes,"ErrorTable");

出现以下错误:

内部错误:无法设置非参数化查询,可能是错误的SQL查询

问题是,在SSMS中查询成功运行.谁能向我解释我错了吗?

感谢

Greetings,
I''m trying to create a mobile application in C#, in which the data of a SQL SERVER table are "pull and push" to a PPC and back again.
I''m using .NET 2005, SQL SERVER 2005 and SQL SERVER2005CE.

Also, in the following code:

string sqlServerConnection = @"Provider =SQLOLEDB;Data Source
=''192.χ.χ.χ'';Initial Gatalog = Hospital_RDA;User Id=sa;Password=123";
SqlCeRemoteDataAccess myRDA = new SqlCeRemoteDataAccess("http://192.x.x.x/Hospital_PatientRDA/sqlcesa30.dll", "DataSource=\\Program Files\\pullmethod\\PullRDA.sdf");
myRDA.LocalConnectionString = "DataSource=\\Program Files\\pullmethod\\PullRDA.sdf";
string strDoctorEmployeeNo = txtDoctorEmployeeNo.Text;
string strCmd = "SELECT * FROM Patient WHERE DoctorEmployeeNo= "+ strDoctorEmployeeNo;
myRDA.Pull("Patient", strCmd,sqlServerConnection, RdaTrackOption.TrackingOffWithIndexes, "ErrorTable");

the following error appears:

Internal error: Failure setting up a non parameterized query, possible incorrect SQL query

The thing is, in SSMS the query runs successfully. Could anyone explain to me where I''m wrong?

Thanks

推荐答案

写道:​​

初始目录



我认为您的意思是目录",而不是目录".



I think you meant ''Catalog'', not ''Gatalog''.


这篇关于RDA拉出错误:无法设置非参数化查询,可能是不正确的SQL查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-02 00:27