I am developing PPC application using SQL Server 2000 and SQL Server CE 2.0.
I succeeded in getting/pulling data from handheld/sql server ce into sql
server 2000 using RDA.
Since all process above done on handheld application, is there any way to

Hello everybody. Some times ago, I write this line of codes to merge my sql
server 2000 database and sql server ce database on my pocket pc.
Private Sub cmdSincro_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles cmdSincro.Click

I am having trouble with a SQL statement that follows
I have 3 tables I a Master table (table2) & I want returned only the
coresponding child rows in table1 where a field (table1.code) is MAX for
each table2.patientid

I'm building an application that explore the content of a SQL Server CE
database.
I can get tables using SELECT * FROM INFORMATION_SCHEMA.TABLES and columns
with SELECT * FROM INFORMATION_SCHEMA.Columns

We are implementing merge replication between a SQLCE 2.0 database on
aPocketPC and a SQL 2000 database. The database model is pretty complicated,
but synchronization seemed to work well. After a period of time
synchronization stops to work fine. No error is returned,but no record

Im not able to download sqlce sp3 from the link provided below:
http://www.microsoft.com/sql/ce/downloads/sp3.asp. I tried 3-4 times
but it downloads about 100-300 kb and then it fails suddenly. i'm able
to download other links so i dont think any problem with proxy server

I am programming PDT8100. The problem is that if I insert about 150 records
(insides a loop) into SqlServerCe database, it takes approximately 57
seconds. But when I insert about 2000 records(insides a loop) it takes
approximately 55 minutes to more than an hour. Hence the total ...

This is a question to Microsoft.
ADOCE almost works for the purposes we need (using C++) but has a couple
of problems - notably the IDL seems slightly out of date.
I know that ADOCE from C++ is not supported and generally CF is the

How can I trap an integrity violation before I perform merge replication on
the device.
I need a way to find out if a specific snapshot will throw sqlce error
28549.  Finding this information from my publication on server before any

Windows Mobile 2003 SE
SQL CE 2000
SQL 2000
Visual Studio 2003

I want to access SqlServerCe database through my desktop C#.Net application,
so that I can insert huge records very fast and then copy this database file
to Pocket PC device.
For inventory purpose, I have to insert 14,000 records in SqlServerCe

Are there any pointers to sample code or walkthroughs for how I can remotely
query an RDA service from my Windows XP PC, not from my mobile device.  I
just want to test some of the calls and queries, but have never developed
with RDA.  Everything I have seen is code written for ...

I'd like to work with SQL CE 2.0, but I don?t work with VStudio.Net, I
use instead Pocket Builder 2.0, is it compatible with it?. How can I use
it?
Thanks in advance!

Hi, initially when i started programming my application in VS.net 2003 i
created a Database with default values, the i made it grow and now it is my
"real" database. I want to change its LCID and set Encription ON and want to
know how to do that. I found in SQL SERVER CE Online ...

Is it possible to get the subscriber name from an existing CE database
with a prevously made subscription?
Thanks
Roman