Click here to Skip to main content
15,892,737 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
Posted

1 solution

wrote:
Initial Gatalog


I think you meant 'Catalog', not 'Gatalog'.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900