I develop my app on the wince 4.2 and sqlce 2.0 using evc 4.0. When I
found the size of the db files cannot shrink automaticlly I searched
for help through this group and I got the answer was the size of db
files with sqlce 2.0 does not increase after any deleting of rows. Now

I remember seeing the memory (RAM) requirements for various data
objects, but I can't seem to find it.
Does anyone know the memory requirements for each SqlCeResultset
object created?  I may need to have several of them open throughout

I would like to know what's better in C# compact framework programming
To declare a SQLCeConnection variable as a Static member of
a Class containing functions to MakeConnection and
CloseConnection, or should I just declare it as a Public

i've full installation Sql Express 2005, now i want installa SqlCe30, i use
Sqlce30setupen.msi but give me an error:
You must firt install the Replication Components for SQL Server 200 Sp 3a or
higher or the SQL Server 2005 Replication Components.

With SQLServer CE 2.0
I have a big DB with a size of 55885 KB.
The size after a compact was 6388 KB.
There is a way to know why the DB grow like this ?

I have an application written in another language (CASL) on a Windows Mobile
platform and I want to convert the databases to SQL Mobile so that I can
create a version of my app for Smartphones. The databases for the CASL app
use a single table that has 17 columns and anywhere ...

I read that ntext should not be used in new SQL 2005 applications,
what is the future of ntext in the compact edition ?
casey

Hi, Does anyone have any resource suggestions for quickly getting up
to speed with synchronizing a SQL CE 2.0 table with a SQL Server 2005
table using USB/ActiveSync from a PocketPC 2002 device? Can this be
done with USB if the user logged into the workstation has access to

Are there any 3rd party class libraries that wrap the Native OleDB
calls (like those in the NorthwindOleDb sample) for SqlServer into
Connection and Recordset classes?
We have a lot of existing C++ code using the standard high level

It seems there is no SqlCeConnectionStringBuilder class. Does anyone know
why?

how can I connect a database access to sql server ce on the same desktop
thank you

I wrote a very simple C# console application which was designed to
give us a rough idea on the performance and reliability of SQLCE (the
source code without metrics has been posted to this group recently).
What I've found is that there are major performance and reliability

I have SQL Server Management Studio Express, SP2 edition. I'm able to create
a CE database but it seems it is a CE v3.1 DB, not 3.5.
Does SMSE support v3.5?
Here is the information I retrieved from the SMSE Help | About:

Hi to all!
I´m developing with .NET 2.0 Compact Edition 1 year, and some of the
developed application are using the SQL-Server-Mobile/SQL-Server-CE. But from
a while I have some questions, which I can´t answer myself.

I've searched through this and other SQLCE newsgroups, and it would
appear that whenever this question is asked, it is deflected or left
unanswered. I'll try again:
Is there any way to create SQLCE database tables from an XML schema