We have an sqlce db on a 128MB SD card, with about 60MB free space. The
size of the db is 8MB. We do a series of INSERTs, UPDATEs AND SELECTs
and after about 25 sets of the above operations, we get the 0x8007000e
error (it is the E_OUTOFMEMORY error in ADOCE3.1 documentation).

i deploy my first application for Pocket PC with SQL CE.
I've a MSDE 2000 that sincronyze with SQL CE RDA connection.
All ok, Select and Update. My problem is Insert
I've a simple table with PK name "Id"

Having some problem connecting to SQL server 2000
database that is installed with a cradle, activesync etc
on my desktop. I am trying to executescalar a a simple
SQL query. I use very conventional way and I totally

I need a SQL CE query that checks to see if a table exists. SQL CE does not
have the option of using the IF operator so already I'm in trouble.
I have a  SQL Query that does a DELETE query if a field is NULL.
If the table does not exist I get an error because the table does not ...

I have an exisiting application using SQLCE, and it works great.  I have to
make a few modifications to it, and there is concurrently an opportunity to
support the Smartphone OS.  Has anyone used the DataSet Server web service
(detailed here:

I currently have an Access database which I sync to a PPC.  I read from the
database on PPC, but do not write to it.  The database gets sync'd upon my
ActiveSync connection.  I am looking to perform the same operation only with
SQL Server 2000 instead of Access.

Hi all gurus,
I've searched a lot but I wasn't able to find out anything to solve my
problem: I've to sync a SQL Server CE table containing an image column
with a SQL Server 2000 via RDA. However, I've not been able to find out

I received the following error : "a call to SQL Server reonciler failed".
Does nayone know why it is happening?

Is there any build-in mechanism in an SQL Server CE database that would
indicate whether the record has been modified, such as a "dirty bit" that I
can turn on/off or do I have to create my own field for that? Thank you.

I am developing CF application that uses SQLCE replication. This
works fine when replicating over LAN Internet connection (when in
cradle using ActiveSync), but when I establish GPRS connection and try
it, it fails with error 28037 (request to send data to machine running

When I enter url
http://arif/sscevd/sscesa20.dll
from any Desktop PC on my LAN, the Server Agent is accessible (displays
Message=>"SQL Server CE Server Agent")

Its normal my dynamic filter works fine to publish, but don't when i try
dispublish?
If i reinitialize all subscriver's ist's work, but have other implications.
Its normal?

can anybody of you give me a small hint how i can handle a
SqlCeDataReader to manage a select statement where probably no record
will be returned because of no record matching the where criteria.
The interesting thing is if the data reader will not find any entry

I am reliably reproducing the ExceptionCode 0xc0000005 native exception
on SQL CE 2.0 simply by issuing a particular SELECT statement against
it. If I issue the statement through ADO.NET, I get the Native
Exception window that displays ExceptionCode (among other things)

It?s Possible Developer a C# application for MPX220, using Sql Server CE ???
Thanks,
Peter