I have been unable to properly install SQL Mobile 2005 on my armv4i windows
CE 5 device.  Below is a summary of what I have found and done.  Any help in
resolving my issue will be appreaciated.  Thanks in advance for your help.
Symptoms:

FOO1 and FOO2 is two table with the same schema.
i am doing some tests to check if a record in FOO1 also exists in FOO2 or
not . First I create a record in FOO1 that does exit in FOO2.
SELECT  ID  FROM  FOO1 WHERE

Environment is SSCE 2.0 and Windows Mobile 5.
I'm attempting to update a base table by using the following code:
Dim CEBaseRecordset As ADOCE.Recordset
Set CEBaseRecordset = ObjectFactory.CreateObject("ADOCE.Recordset.3.1")

I'm using SqlServerCE 3.0 on an HP hx2790 PocketPC.
I have a little problem doing a search with like on a column that have a
multiple column index.
To reproduce the problem I do the following from the Query Analyzer 3.0:

I have Pocket PC where the .net 2005 framework installed
Also, I have XP sp 2 with .NET 2005 , SQL server 2005 installed
I also installed the Mobile replication and I created the convenient IIS
virtual directory.

Does anyone have an example on how to call the CompactDatabase() method in the Engine object in native (c++) (as described in http://msdn2.microsoft.com/en-us/library/ms174034.aspx)? I cannot find the Engine object anywhere... :)
Best regards,
Ole-Johan Ellingsen

How do I programmatically create a SQL Mobile database in a VS 2005 Windows
Forms application on my desktop, and then populate it from a SQL Server
database?
Cheers,

I found a peculiar thing while working with SQL Mobile in a
multithreaded application (VS2005, application for Pocket PC 2003).
I created a class which has multiple SqlCeConnection objects (one for
each table in the local SQL Mobile database). Every time I call a

We have a .NET CF application we are developing.  This application using a
desktop client application.  This is an off the shelf application we are
building so the average Joe will be using this.  With SQL Mobile 5 do I have
to have a SQL server outside the mobile device?  I have ...

I have experienced several occurrences of error 25514. This is not exactly
reproducable, but I think I know where it is occurring. The MSDN site says
to contact Microsoft Product Support Services, but they do not say how.

We have a serious issue with an application we develop using VS.NET 2003
and SQL CE 2.0.
We sporadically encounter the "Not enough storage is available to
complete this operation" exception when our C#.NET CF 1.0 SP3

As far as I know there is no service pack for SQL Server CE 2.0 but I've
noticed that the version of sql ce that comes with Visual Studio 2003 is
different from the one in Visual Studio 2005.
I've installed both version on a PPC2003 form the following folders (default

I manage an eVC app that uses SQL Server CE 2.0 and want to do a
Compact on the DB only when it *needs* it.
Is there any way of detecting fragmentation in a DB? Perhaps some
benchmarks I could follow? I would follow with a Compact accordingly...

Hi,
I want to store data on my Pocket PC in an SDF file and then use ActiveSync
(4.0) to have that SDF file synced to the desktop. Right now I can save the
file to \My Documents folder on the pocket pc and have ActiveSync

I need some ideas to solve my problem : I've a device (x86) with installed
Windows CE 5. This device have a program that run and save different
information in SQL Mobile database. One PC connected thougth ethernet can
request data to my device thougth a normal query (SELECT * ...