I am using a SQL Server CE 2.0 database on a Win CE 4.2 Pocket PC.
  In a table, there are some records that have primary key = null. The
other columns of these records have null value although I set not null
constraint on them.

I have an error when i try to sincronize up the data from my Pocket Pc to my
SQL DB.
Greetings
JR

Hi Gurus,
Does anybody know whether SQL Mobile works on xp embedded or not?
If yes, could you point me to some links that I can find more
information?

I'm in the process of a 'forced' upgrade (my client bought newer PocketPCs).
Soooo .. what I would like to know is whether there are any issues
connecting SQL Mobile to SQL 2000 for replication. Currently, replication
works "as advertised" between SQLCE and SQL2000.

I need to handle some sdf files on a ppc with vb.net 2003.  but the files
are not available by the system.io as they are locked by the sqlce engine.
I would like to know if it is possible to shut down temporarily the sqlce
engine in order to play with these files

I'm wondering how to distribute SQL 2005 Mobile to end users.
Is there any installer for this, like the one for .NET compact framework
(http://www.microsoft.com/downloads/details.aspx?familyid=9655156b-356b-4a2c-857c
-e62f50ae9a55&displaylang=en)
?

In my Database I've some records in my SQL Mobile 2005 Databse  with
the date of 01.01.1900 which means in normal SQL Servers as  "0/ empty
Date".
Now when I select these rows, the Dataset in .NET has 01.01.2000 as

I can't get this sample to compile.  The first error I get is that it
cannot find oledb.h.  When I include the path to an older version of
oledb.h, other errors appear.
1. Does someone have a check list with all of the required directories

I'd like to write a software on a pocket pc that should access a sql server
database directly using a wifi connection.
What's the best way ?
asp, sql ce, ... ?

I'm wondering about licensing issues of using SQL Mobile 2005 in Open Source
projects.
We are going to develop software which will be released as open source
project and we are gong to use SQL Mobile 2005 for storage data on device in

Generally I think that it is good practice to close a database connection as
soon as the job using it finishes. But I'm working on a Pocket PC
application where speed is very important, I find that opening and closing
the database connection makes my application slower.

I'm facing up a very strange trouble others encountered but no solution can
be found on the Web.
I want to insert several rows in a table containing one field of ntext type
(I need to store strings bigger than 255 car.).

I'm trying to create a 'YTD Actual' calculated measure in AS2005. Using the
cube designer, under the Calculations tab I have the following code:
CREATE MEMBER CURRENTCUBE.[MEASURES].[YTDActual]
AS YTD([Measures].[Actual Value]),

I’ve asked:
"I’m still (unanswered: RDA and large table problem   1/15/2006 11:17 AM PST)
trying to pull large (many columns - 250) table to my PDA. This time with SQL
Server 2005 and SQL Server Mobile. And it does not work. Pulling small table

It there a way to replicate data from an SQL Server Mobile database to an
ORACLE database?
Thanks in advance for the kind reply