I am modifying my application/database and am having a weird problem. I have
developed an app on a pocet pc using eBv, SQLCE and backend SQL2000. Data is
pulled to the SQLCE using trackingon and data is pushed back to SQL2000 using
the push command. I am pulling 2 tables plus 2 ...

I 'm using OLE DB Provider for SQL Server CE to create password-protected
database. Everything is working great but I can't find how to define a
database collation. I'm wondering if I can use DBPROP_INIT_LCID property? I
will be grateful for any example.

   using Query Analyzer, i have created a new sdf file successfully. but
when try to execute following sql command
   CREATE TABLE [MyTable] ( [field1] [int] NOT NULL)
  always get failed message.

From an application written in evc++ i tried to compact the sql ce database.
I closed a connection to the local database in the application by calling
the close() methid of Cdatasource class.
THen called the routine for compacting the local database.

Hi, there
I want to know if there is any way to generate the Script of the entire
database from the SQLCE database. Any suggestions?
Thank you

Is there a stored procedure in SQL Server, or did any of you created one, to
run the snapshot agent after (re)creating a merge replication?
Thanks,
Alberto Silva

Can anyone tell me, if its possible to run a command for compacting SQL CE
database command from the query analyser.
If so how to we do it.
Will it give a sharing violation??? if an application is using the db???

I'm looking for a way to remove data from a merge replicated database
that would be filtered out if it was synchronized for the first time
today.  In addition, I don't want the new rows to be deleted from the
publisher's database.

Help required, can't find mention of this bug anywhere.
I am trying to use the SQLCE (2.0) Query Analyzer on a DELL AXIM X30 Pocket PC [Intel PXA270; Windows Mobile 2003 Second Edition Version 4.21.1008(build14059)].
I am finding that the Tools & SQL menus are not being displayed, ...

I would like select in my database just 5 or 10 first row.
Did you how can i do?
I have try this request but without succes!
I have not found explanation in the sql server ce doc.

Hi
im trying to close the connection, compact the database and open it again.
While doin so i got 2 errors
1)native error 28550 (cannot compact sql server ce)

I have created databases with an application developed in Embedded Visual
C++ 4. When the application is running and it is connected with the database
created by it I reseted the Pocket PC. Sometimes, after it happened I can't
open the database again, even using the query ...

We've had enough with SQL CE!
It's data corruption problem is just too much
for us and our customers to bear.
We are looking for mobile database alternatives.

Friends,
  My PocketPC application requires a database to be created and a couple of tables to be RDA_pulled from the desktop. Is there any way to find out how many tables are already present so that they tables need not be pulled again.
Thanx in advance
Suvransu

I installed IBuySpyDelivery on my W2k SP4 PC.
On the PC I have a connection to sscesa20.dll.
But on the emulator I don't have any chance to connect. I got always error 80072EFF (internet connection reset). I don't have any
real device, just the emulator.