I'm using SQL Server Compact Edition 3.5 and I need to get row number
in my query. How can I do this?
Thanks for help!

Does anyone know when/if a SP is going to be released for this issue?  I
can't release a hotfix to a customer.
Thanks,

When I try to exit my program in PDA.
it give me the error below.
RealTimmeMobileSys.exe
SqlCeException

When i am doing a rda push to sql server, i get this error message "The
Table is not a tracked table".
My question is where or how do i specify whether the table is a tracked
table or not?

I'm accessing SQL Compact 3.5 database using OLEDB provider.
pConnection->Open(L"Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data
Source=c:\\db.sdf;Persist Security Info=False", L"", L"", -1)
I'm trying to execute simple "select" query.

Can I connect to a remote SQL Compact database on an device when I know the
directory where the database is on the device and its IP address?
For example from management studio or a desktop application  that I write my
self.

Env.: CF3.5, SQL CE 3.5
Hi All,
I have a table with an nvarchar(200) column. Occasionally, my app will try
to insert a new row with a text longer than 200 chars in this column. The

       I am looking for a Database solution that can work remotely on
PDA to communicate to central database server thru Wifi connection. So
far it appears that SQLserver Compact Edition can do that (via IIS,
according to MS website). Is this true? With this Compact Edition, can

Can anyone point me to a smart device sample for merge replication that
would work with SQL Server 2005 and SQL Compact 3.5?  I have what I think is
a suitably-prepared server database, publication, etc., but don't see how to
create a subscription with the tools, and can't figure ...

Guys, I'm confused.  There seems to be more to choose from for a
mobile database than days of the week.  I am starting a mobile app
that will require RDA or merge replication back tp a SQL 2005
installation over a WiFi network.  I am developing the desktop client

Seems Sql CE is not fully supported on 64 bit machines.
I was able to create one on my machine and build a schema but could not
connect to it through code.
Is it just the drivers used for development?

I want to find missing data from a table. For example there are 1,2,5,7 in a
table. Here max is 7 and min is 1. Now missing data within max and min are
3,4,6. So how can find missing data.

I use the following example for the description:
"UPDATE Table SET Column1=@Value1"
In code I create a parameter and add it to a list which is passed to
the execution:

Oops, accidentally posted this to the C# group so apologies for cross
posting.
VS2008 IDE Desktop app.
Anybody out there deploying this db?

plz give a valable suggestion to the write query