I know that there is a new version of sql CE called SQL Mobile
that comes with SQL Server 2005. My question is that if I have an
application written that uses SQL CE 2.0, can it be installed on a
device with WM 5.0 ?. How easy is to upgrade the application?

It would be nice if one can convert a SQL DB to SQL CE/Mobile DB?
Any ideas?

Hi...
 In Embedded VC,While I execute an insertion query I am getting
'DB_E_ERRORSINCOMMAND' exception but the same query gets executed in
Query Analyzer and connection string is correct..

 I having a query as follows,
queryStr = "SELECT isNull(MAX(sequenceId), 0) AS seqId FROM "
                "collSeq WHERE schObjId IN "
                "(SELECT schObjId FROM scheduleObj WHERE "

I am using VB.NET 2005 and DataGridView to access Mobile SQL 3.0
database on my pocketpc device thru ActiveSync with the application
runing on my PC(desktop)..  If I copy my Mobile SQL 3.0 database to my
PC...then I can access the file fine using DataGridView.  If I try to

I am almost embarrased that I can not find this answer myself.
I'm used to oracle, and I'm needing to do something in sqlce and I'm not
having a lot of luck.
What is the magic to make "SELECT 'x' FROM dual" work in sqlce?

Can I Use sqlmobile30devtoolsenu with SqlExpress ?

There is no emulator for ce 5.0 integrateed in the development tools, is it?
So I have downloaded a stand-alone emulator from Microsoft downloads site.
Its very ok, but I have a serious problem. I can't integrate it with the
medium...IS there a way to register it in the medium?

I have a desktop application built with a VB.NET GUI and a Microsoft Access database and I want to deploy parts of the application on a Pocket PC device. I have discovered that there is a SQL Server CE database engine that can be used on the pocket PC devices. My question is how ...

Is possible to copy the table structure from a Sql2000 table to sql ce 3.0
database ?

I have a sql server 2000 Database that is equal with the sql server ce
Database.
If I use this query :
Select MultilingualText from Texte where DefaultTextID = ( Select

I continous my test to use the eVC++, now I have a good code that
copile correctly byt when I try to execute at the emulator by the eVC++
4.0 it give this error messsage:
"An application targeting a Standard SDK for Windows Ce .Net and built

I have read recently that it is possible to manage SQL Server Mobile
Edition database from desktop computer with SQL Server Management
Studio 2005 or Visual Studio 2005.
Is it possible to use these two tools to manage SQL CE 2.0 database

I am new in SQL CE and i want to synchronise an SQL CE database from
my iPaq device with an SQL database of my desktop pc that has SQL
server and the other way aroung. How can i do this?
Is there somebody that can give me instructions or a usefull link to do

I am trying to install SQL Mobile Server Tools (beta 1) in my SQL
Server 2000 SP4 server.  I have already installed the SP4 Replication
Components upgrade and my existing SQL-CE databases replicate ok,
however when trying to run the SQL Mobile Server Tools (beta 1) install