RDA拉出错误:无法设置非参数化查询，可能是不正确的SQL查询 [英] RDA Pull error:Failure setting up a non parameterized query, possible incorrect SQL query

问题描述

问候，
我正在尝试使用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查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！