Click here to Skip to main content
13,089,818 members (47,090 online)
Rate this:
 
Please Sign up or sign in to vote.
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 11-Jan-10 21:40pm

1 solution

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

Solution 1

wrote:
Initial Gatalog


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

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 |
Web03 | 2.8.170813.1 | Last Updated 12 Jan 2010
Copyright © CodeProject, 1999-2017
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