The scenario is that I have an sdf file that when trying to open in isql_ce
is corrupted.
So I try to compact it. No go.
The error  I get says that  the table cannot be found. The error parameters

All,
My app compiles fine (yes, I know, that proves nothing) using ssceoledb30.h
A simple call to open an Accessor on the sdf file (in the correct directory)
keeps returning "Class not registered".  I've inherited from CDataSource and

Does anyone here know whether the Pivot function (being added to SQL 2005)
will be available in SqlMobile?  I haven't been able to find anything
detailing the functions and capabilities of Sql Mobile?  VS2005 comes with a
help file for SqlMobile but it only addresses install.  ...

we are developing a few mobile apps using sql ce. we want to know if we can
avoid using RDA or merge replication. Are there any direct methods we can
use without them?
TIA

 We are struggling to set up Merge Replication model in our customer
environment, and currently we met some problems.
A. Phenomenon:
 When syncing from pda, we got exception as follows:

This property is confusing me on the sp_addmergefilter for merge replication
For example if I have OrderItems to Order filter and I join on the foreign
key OrderItems.OrderID to Order.OrderID would this mean I should set this to
true even though there could be duplicate OrderID's ...

Is it safe to assume that any Windows Based PDA will run SQL CE.
In particular, we are interested in the Dell Axim x50, a Windows Mobile 2003
Second Edition based processor.
Our software is based on VB.NET 2003 and Compact Framework 1.1.

SQLCE drives me nuts sometimes.
The lack of NULLIF and ISNULL have created some painful queries for me.  I
have a date column that I query and bind to a datagrid.  I want 1/1/1900 to
appear as empty, so I create a query like this (remember, no NULLIF):

I would like to push a non pulled table from SQL CE to the sql server, does
any one know if this is possible. Perhaps its possible to make C#/SQL CE
think the source table is a pulled one.
If this isn't possible, can rda.SubmitSql be used to upload a whole table

When I attempt to create a subscription on the mobile server, I am able
to connect fine, but it displays the message 'There are no publications
to which you can subscribe'.  I've connected as both sa and an admin
user - no luck.  I'm trying to populate an .sdf and copy it to the

Does anyone know where I can find some useful information (preferably
examples) of inserting, updating, and selecting data from a Sql Server
CE database using embedded C++ 4.0?  Most of my experience is using C#
but in order to test out a possible solution for a project, I may need

I want to make merge replication between a SQL Server 2000 DB and SQL Server
CE on the device.
As I use Windows XP Home Edition I have no possibility to use IIS (is this
correct?). Is merge replication possible without IIS if I only use the cradle

I know that the Tracking on RDA is used to track which changes made on
the device should be propagated back to the SQL Server DB via the Push
method.  Is there any way I can do a Pull and keep my existing DB on
the device and only bring the records down that have changed or would I

I'm trying to run NorthwindOleDb sample included in VS2005/SQLMobile on a
Windows CE 5.0 (ARMV4i) device. The original sample did not build for Windows
CE 5.0  device so I created a new project and started to copy functionality
but I can't pass CoCreateInstance, it returns ...

I have a Visual Basic program and I am trying to build a SQLCE table
that has about 150 rows already inserted into it.
My code looks like this:
           Dim Rowincrement As String