RDA unable to pull data

Hello -

I am trying to pull data from SQL Server 2000 database onto my Pocket PC and the simple query works on Northwind sample database but does not on another custom build database. I did test the statement in the SQL Query Analyzer and it works.

The error I get is: "Failure setting up a non parameterized query, possible incorrect SQL query."

I know the code is right - thanks to Rory B's screenscasts. Any guidance will be greatly appreciated!

Thanks!

Moldau

Here is the code:

private void RdaPull()

{

try

{

//Create the database

if (File.Exists("\\My Documents\\Test.sdf"))

File.Delete(\\My Documents\\Test.sdf);

SqlCeEngine engine = new SqlCeEngine();

engine.LocalConnectionString = localConnection;

engine.CreateDatabase();

engine.Dispose();

//Initialize RDA Object

SqlCeRemoteDataAccess rda = null;

rda = new SqlCeRemoteDataAccess(rdaUrl, localConnection);

rda.Pull ("Customers", "select * from Customers", rdaOleDbConnectionString);

rda.Dispose();

MessageBox.Show("Done");

}

catch (SqlCeException ex)

{

MessageBox.Show(ex.Message);

}

From the sample code you have dumped, I dont see any issue. Can you please elaborate on what are all the configurations you have at IIS, SQL Server, Device so that we know the environment. This is a very basic operation and it should not fail. It worries me hearing that a basic scenario like this fails in your case!

Please provider as much detail as you can so that we have a good understanding of the problem environment.

Thanks,

Laxmi

|||

I am facing the same issue. I have several published examples of RDA and have followed them exactly. As soon as the Pull method is called I receive the error:

28622 Internal Error: Failure setting up a non parameterized query, possible incorrect SQL query.

Has anyone discovered what may be causing this?

|||

Hi

I had exactly the same error

Failure setting up a non parameterized query, possible incorrect SQL query.

this error was caused by a mistake in my SQL query. i hope this will help some of you!

Reguards.

|||

Check your sqlcesa30.log file from browser.

In my case it was :

2007/04/08 00:09:31 Thread=1398 RSCB=36 Command=PULL Hr=80040E09 SELECT permission denied on object 'Stolik', database 'rms', schema 'dbo'. 229

I changed my anonymous user permissions and everything works fine now.

RDA unable to pull data

Hello -

I am trying to pull data from SQL Server 2000 database onto my Pocket PC and the simple query works on Northwind sample database but does not on another custom build database. I did test the statement in the SQL Query Analyzer and it works.

The error I get is: "Failure setting up a non parameterized query, possible incorrect SQL query."

I know the code is right - thanks to Rory B's screenscasts. Any guidance will be greatly appreciated!

Thanks!

Moldau

Here is the code:

private void RdaPull()

{

try

{

//Create the database

if (File.Exists("\\My Documents\\Test.sdf"))

File.Delete(\\My Documents\\Test.sdf);

SqlCeEngine engine = new SqlCeEngine();

engine.LocalConnectionString = localConnection;

engine.CreateDatabase();

engine.Dispose();

//Initialize RDA Object

SqlCeRemoteDataAccess rda = null;

rda = new SqlCeRemoteDataAccess(rdaUrl, localConnection);

rda.Pull ("Customers", "select * from Customers", rdaOleDbConnectionString);

rda.Dispose();

MessageBox.Show("Done");

}

catch (SqlCeException ex)

{

MessageBox.Show(ex.Message);

}

From the sample code you have dumped, I dont see any issue. Can you please elaborate on what are all the configurations you have at IIS, SQL Server, Device so that we know the environment. This is a very basic operation and it should not fail. It worries me hearing that a basic scenario like this fails in your case!

Please provider as much detail as you can so that we have a good understanding of the problem environment.

Thanks,

Laxmi

|||

I am facing the same issue. I have several published examples of RDA and have followed them exactly. As soon as the Pull method is called I receive the error:

28622 Internal Error: Failure setting up a non parameterized query, possible incorrect SQL query.

Has anyone discovered what may be causing this?

|||

Hi

I had exactly the same error

Failure setting up a non parameterized query, possible incorrect SQL query.

this error was caused by a mistake in my SQL query. i hope this will help some of you!

Reguards.

|||

Check your sqlcesa30.log file from browser.

In my case it was :

2007/04/08 00:09:31 Thread=1398 RSCB=36 Command=PULL Hr=80040E09 SELECT permission denied on object 'Stolik', database 'rms', schema 'dbo'. 229

I changed my anonymous user permissions and everything works fine now.

RDA unable to pull data

Hello -

I am trying to pull data from SQL Server 2000 database onto my Pocket PC and the simple query works on Northwind sample database but does not on another custom build database. I did test the statement in the SQL Query Analyzer and it works.

The error I get is: "Failure setting up a non parameterized query, possible incorrect SQL query."

I know the code is right - thanks to Rory B's screenscasts. Any guidance will be greatly appreciated!

Thanks!

Moldau

Here is the code:

private void RdaPull()

{

try

{

//Create the database

if (File.Exists("\\My Documents\\Test.sdf"))

File.Delete(\\My Documents\\Test.sdf);

SqlCeEngine engine = new SqlCeEngine();

engine.LocalConnectionString = localConnection;

engine.CreateDatabase();

engine.Dispose();

//Initialize RDA Object

SqlCeRemoteDataAccess rda = null;

rda = new SqlCeRemoteDataAccess(rdaUrl, localConnection);

rda.Pull ("Customers", "select * from Customers", rdaOleDbConnectionString);

rda.Dispose();

MessageBox.Show("Done");

}

catch (SqlCeException ex)

{

MessageBox.Show(ex.Message);

}

From the sample code you have dumped, I dont see any issue. Can you please elaborate on what are all the configurations you have at IIS, SQL Server, Device so that we know the environment. This is a very basic operation and it should not fail. It worries me hearing that a basic scenario like this fails in your case!

Please provider as much detail as you can so that we have a good understanding of the problem environment.

Thanks,

Laxmi

|||

I am facing the same issue. I have several published examples of RDA and have followed them exactly. As soon as the Pull method is called I receive the error:

28622 Internal Error: Failure setting up a non parameterized query, possible incorrect SQL query.

Has anyone discovered what may be causing this?

|||

Hi

I had exactly the same error

Failure setting up a non parameterized query, possible incorrect SQL query.

this error was caused by a mistake in my SQL query. i hope this will help some of you!

Reguards.

|||

Check your sqlcesa30.log file from browser.

In my case it was :

2007/04/08 00:09:31 Thread=1398 RSCB=36 Command=PULL Hr=80040E09 SELECT permission denied on object 'Stolik', database 'rms', schema 'dbo'. 229

I changed my anonymous user permissions and everything works fine now.

RDA unable to pull data

Hello -

I am trying to pull data from SQL Server 2000 database onto my Pocket PC and the simple query works on Northwind sample database but does not on another custom build database. I did test the statement in the SQL Query Analyzer and it works.

The error I get is: "Failure setting up a non parameterized query, possible incorrect SQL query."

I know the code is right - thanks to Rory B's screenscasts. Any guidance will be greatly appreciated!

Thanks!

Moldau

Here is the code:

private void RdaPull()

{

try

{

//Create the database

if (File.Exists("\\My Documents\\Test.sdf"))

File.Delete(\\My Documents\\Test.sdf);

SqlCeEngine engine = new SqlCeEngine();

engine.LocalConnectionString = localConnection;

engine.CreateDatabase();

engine.Dispose();

//Initialize RDA Object

SqlCeRemoteDataAccess rda = null;

rda = new SqlCeRemoteDataAccess(rdaUrl, localConnection);

rda.Pull ("Customers", "select * from Customers", rdaOleDbConnectionString);

rda.Dispose();

MessageBox.Show("Done");

}

catch (SqlCeException ex)

{

MessageBox.Show(ex.Message);

}

From the sample code you have dumped, I dont see any issue. Can you please elaborate on what are all the configurations you have at IIS, SQL Server, Device so that we know the environment. This is a very basic operation and it should not fail. It worries me hearing that a basic scenario like this fails in your case!

Please provider as much detail as you can so that we have a good understanding of the problem environment.

Thanks,

Laxmi

|||

I am facing the same issue. I have several published examples of RDA and have followed them exactly. As soon as the Pull method is called I receive the error:

28622 Internal Error: Failure setting up a non parameterized query, possible incorrect SQL query.

Has anyone discovered what may be causing this?

|||

Hi

I had exactly the same error

Failure setting up a non parameterized query, possible incorrect SQL query.

this error was caused by a mistake in my SQL query. i hope this will help some of you!

Reguards.

|||

Check your sqlcesa30.log file from browser.

In my case it was :

2007/04/08 00:09:31 Thread=1398 RSCB=36 Command=PULL Hr=80040E09 SELECT permission denied on object 'Stolik', database 'rms', schema 'dbo'. 229

I changed my anonymous user permissions and everything works fine now.

RDA Pull from Windows Server 2003 gives Native Error 28035

I currently have a Vs.Net 2003 Pocket PC application that uses sql server ce 2.0 to push and pull data from Sql Server 2000 to the Pocket PC. The sscesa20.dll isapi agent is installed on a Windows 2000 server and points to another server that hosts the SQL database. In this configuration everything works like a charm. I am in the process of upgrading my application server to Windows 2003 Server but the RDA PULL process does not work, giving an Native Error of 28035 EVERY time. I use the exact same code in the app but when I point to the isapi agent on the 2003 box it does not work. When I connect to the the sscesa20.dll via the Pocket IE it returns the "Sql Server CE Server Agent" message. When I do an RDA.Submit it works and the SQL table is updated as expected.

I have configured IIS 6 with the proper web extensions
I have turned off the firewall and antivirus on the server.
I have reinstalled the server agent several times.
I set up the sscesa20.dll manually.
I removed all file level security.
I opened up the virtual directory.
I verified the ddl versions match.

I'm dead in the water right now. I'm not sure what else to try.

Any help would be greatly appreciated.

Error 28035 indicated that the header information that the server tools are using to broker the RDA is missing or corrupted. The typical cause of this is that you have a security product somewhere in the path from your mobile device to the publisher (SQL Server) that is stripping off the content lengths on the replication HTTP dialogue. You need to completely disable any internet security products like Symantec or McAffee on both your IIS and your SQL Servers.

Darren

|||

Darren,

Thanks for the info. I'm sure it's not the SQL Server because I don't get any errors when I RDA pull using the Windows 2000 Server implimentation of the ISAPI agent. I've turned off all the firewalls but my provider is a little hesitant to turn off the anti-virus products. I'm perplexed because everything works fine with my Windows 2000 Server. Everything points to this being a Windows Server 2003 specific problem. I'm going to work with the ASP to get the anti virus out of the equation too.

|||

Hi Tstay,

Did you resolve the problem?

What is the behavior when you turned of Anti virus?

This error also occurs in case of SQL Mobile 3.0 Client Agent is trying to contact SQL CE 2.0 Server Agent (OR) SQL CE 2.0 Client Agent is trying to contact SQL Mobile 3.0 Server Agent. Make sure that you are using same version of SQL Mobile/CE both on device and as well as on IIS.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||

We turned off the anti-virus and the firewall and I'm still getting the error. The Sql CE version on the device and the server match. We have come to the conclusion that it's a 2003 or IIS 6 issue, so we have no choice to roll back the OS to 2000 until we have more to go on with 2003. Any advice would be appreciated.

thanks

RDA problem with SQL Server 2005

My company just converted to SQL Server 2005. I have a pocket PC application, developed with Visual Studio 2003, that is now giving me an RDA problem.

Two tables push fine but the third gives me the error:

"ERR: Push for Table Events: System.Data.SqlServerCe.SqlCeError: The OLE DB data type information in the SQL Server CE columns does not match the information in the SQL Server columns for the RDA table. [Client type, Server type,,Table name,,]"

This is despite dropping all the tables and doing an RDA pull from the database. I don't see anything different on this third table than the other two.

Any suggestions would be appreicaed.

Correct error handling should tell you which data type are in conflict from the error parameters collection, see http://msdn2.microsoft.com/en-us/library/ms174079.aspx|||

My error parameters are as follows:

Error Paramaters

(0)=""

(1)=""

(2)=""

NumericError Parameters

(0) = 0

(1) = 0

(2) = 0

Can anyone help me understand if this is of help!

|||This is obviously not very helpful at all! Could you try to make a "Create table" script of the problematic table, so we can see how it is defined.|||

I'm not sure what you mean by this script, but here is my table definition out of Sql Server 2005:

Event Number(PK, varchar(13), not null)

TransfectionNumber (FK, varchar(13), not null)

type (nvarchar(1), not null)

HHDeleteDate(smalldatetime, null)

Note(nvarchar(255), null)

Keys

PK_Events

FK_Events_Transfections

I pull this table, and all the others, using RDA so the definition should be coming over fine.

I use similar column definitions on other tables without problems

Thanks,

Ron

|||

With some further testing, it's possible my problem is occuring because of the name "type" in the table. Is there a way to change the name in the SQL CE database easily. Otherwise, I'll need to reenter data captured over the last week.

Ron

|||

That sounds like it, Ron. '

SQL CE's SQL syntax does not allow you to rename a column.
You must save the column data, drop the column, add the new column, and restore the old data in the new column.

Some of the tools from www.primeworks-mobile.com will also be able to help you.

RDA problem

Im having problems with my Pocket PC application deployed in Pocket Pc 2003 se Emulator... Im using the Pull method of RDA. I get the error "A request to send data to the computer running IIS has failed.". I have setup my desktop IIS and I can access the dll agent through Internet explorer. But when I try to access it on the Internet Explorer of the Emulator using the ip of my desktop instead of localhost, I get the error "Unable to connect: You have no modem entries created, and no network card present".
I check the Emulator Connection Settings, and it is set to "My Work Network". I tried using ActiveSync 4.2 then using Device Emulator Manager to put the emulator in Cradle. But still I cant access the remote Internet URL (http://ipaddress/vdirectory/sqlcesa30.dll) on the emulator ...

I guess its the reason I cant use the Pull method... Can anyone help me with this? Its almost 2 days and yet I can't solve this.. Im just starting with C# and pocket PC.. Thanks..

Have you tried to "cradle" your emulator ? (from the Device Emulator Manager, right click and select Cradle). That will enable a network connection to your desktop PC.

|||Yes, I have done that. Fixed this one already, I just configured Activesync to accept DMA... Before it was not enabled so whenever I cradle the emulator, nothing happens, ActiveSync wont detect it...

Thanks

RDA Error

Hi all,

I am developing a Pocket PC application for synchronization SQL server 2005 and SQL CE whenever i am call a RDA's method like Pull() on my application all parameter is correct but this method give a error: "Header information is either corrupted or missing. [,,,Header name,,]", so Please help me how to solves this problem.

Hi Pavan,

Move to Sql Server Compact Edition forum, where would increases the chances for getting your question answered.

And, in most cases, this is the network configuration issue or parameters not set correct. So, could you access the server agent in IIS from your Pocket IE? And, if possible, could you please list out some code snippet, where throws the exception?

Thanks,

Zero Dai - MSFT

|||

Hi Zero Dai,

thanks for reply.

RDA - vb 2005 app - desktop & pocket pc emulator - error: 80072F76 native error: 28035

RDA - vb 2005 app - desktop & pocket pc emulator - error: 80072F76 native error: 28035

PDA info:
.NET CF 1.0 env-string...
MS SQL client
MS SQLCE 2.0 dev
MS SQLCE 2.0

DESKTOP info:
Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

copied an app from http://www.codeproject.com/netcf/PocketPCwithSQLCE/PocketPCwithSQLCE_Src.zip

modified its CONFIG.XML to...
<?xml version="1.0" encoding="utf-8" ?>
<Configuration>
<DatabaseServer>192.168.1.89</DatabaseServer>
<DatabaseName>D1Temp</DatabaseName>
<DatabaseLogin>sa</DatabaseLogin>
<DatabasePassword></DatabasePassword>
<SQLCEURL>http://192.168.1.89/SqlMobile/sqlcesa30.dll</SQLCEURL>
<LocalDBConnect>Provider=Microsoft.SQLServer.OLEDB.CE.2.0; Data Source=\My Documents\MyFav.sdf;</LocalDBConnect>

<LocalDBLocation>\My Documents\</LocalDBLocation>
<LocalDBName>MyFav.sdf</LocalDBName>
<IISLogin>192.168.1.89/Jason</IISLogin>
<IISPassword>batman2005</IISPassword>
</Configuration>

error is "Header information is either corrupted or missing. [,,, header name,,]"

have spent weeks google-ing trying to get this to work, to no avail.
Has ANYONE got RDA PULL to work with above setups?

You seem to be using a wrong combination!

On device it is SQL CE 2.0 and on IIS Server it is SQL CE/Mobile 3.0 as per the URL <SQLCEURL>http://192.168.1.89/SqlMobile/sqlcesa30.dll</SQLCEURL>.

Which is NOT SUPPORTED and this is the error you would get. Try using SQL CE/Mobile 3.0 on the device side then you will be out of the problem!

Thanks,

Laxmi

RDA - vb 2005 app - desktop & pocket pc emulator - error: 80072F76 native error: 28035

RDA - vb 2005 app - desktop & pocket pc emulator - error: 80072F76 native error: 28035

PDA info:
.NET CF 1.0 env-string...
MS SQL client
MS SQLCE 2.0 dev
MS SQLCE 2.0

DESKTOP info:
Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

copied an app from http://www.codeproject.com/netcf/PocketPCwithSQLCE/PocketPCwithSQLCE_Src.zip

modified its CONFIG.XML to...
<?xml version="1.0" encoding="utf-8" ?>
<Configuration>
<DatabaseServer>192.168.1.89</DatabaseServer>
<DatabaseName>D1Temp</DatabaseName>
<DatabaseLogin>sa</DatabaseLogin>
<DatabasePassword></DatabasePassword>
<SQLCEURL>http://192.168.1.89/SqlMobile/sqlcesa30.dll</SQLCEURL>
<LocalDBConnect>Provider=Microsoft.SQLServer.OLEDB.CE.2.0; Data Source=\My Documents\MyFav.sdf;</LocalDBConnect>

<LocalDBLocation>\My Documents\</LocalDBLocation>
<LocalDBName>MyFav.sdf</LocalDBName>
<IISLogin>192.168.1.89/Jason</IISLogin>
<IISPassword>batman2005</IISPassword>
</Configuration>

error is "Header information is either corrupted or missing. [,,, header name,,]"

have spent weeks google-ing trying to get this to work, to no avail.
Has ANYONE got RDA PULL to work with above setups?

You seem to be using a wrong combination!

On device it is SQL CE 2.0 and on IIS Server it is SQL CE/Mobile 3.0 as per the URL <SQLCEURL>http://192.168.1.89/SqlMobile/sqlcesa30.dll</SQLCEURL>.

Which is NOT SUPPORTED and this is the error you would get. Try using SQL CE/Mobile 3.0 on the device side then you will be out of the problem!

Thanks,

Laxmi