Click here to Skip to main content
12,549,345 members (47,637 online)
Rate this:
Please Sign up or sign in to vote.
See more: C#
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?

Posted 11-Jan-10 21:40pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Initial Gatalog

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

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.161021.1 | Last Updated 12 Jan 2010
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100