Is it possible to upgrade a SQL CE 3.1 database to 3.5 in Windows CE 5.0?  I
see that SqlCeEngine has a method called Upgrade, but every time I call it it
throws an exception with this error message:
The specified module could not be found

I am getting strange results running a SqlCeCommand (v3.1) in a .NET
application.
It is a select command, and the bug (?) depends on the first time the
command is used to retrieve results.  

I am very disappointed with the sql queries performance in sql ce. In my
some queries i have inner joins on 9 tables some tables have more then 150000
records. Db size is around 15 MB. If i run that query with particular where
clause (ex RoomNo. = 100)  then it gives result in 1 ...

I don't know if this is the right forum to post this in, but I will start
here....
I am writing a desktop database application. I created a simple SQL CE
database. I then created a new form and dragged the DataGridView control from

I've been struggling to get the prerequisites correct for some time now.
What I have:
I have Visual Studio 2005 Professional
  Express editions of VS do not suit my needs

Hi Gurus,
MSSQL servers are among the most commonly used servers. But we also
know that MSSQL server security is a critical concern for most of the
database administrators. This task will become handy with the help of

Is there any MSM (Merge Module) files available to distribute the SQL CE
3.5. I have the MSI downloaded from MS downloads page, but I want to
integrate the installation with my applications setup.
As I need only the OLEDB features to populate the database on desktop, can I

I'm facing a problem about the interaction between desktop Pcs and palmtops
that apparently is not documented.
I have got a C# device application running on a PPC with Windows Mobile 5
and SQL Server 2005 CE. I would like to establish a connection with an

I have a password secured 3.1 database that has been corrupted (don't know
why). However, when I try to do a verify or repair I cannot access the
database with the original password, I get the message that the password is
incorrect.

Can i insert a record in a table B during reading records in a table A (Sql
Compact Edition 3.1)?
Something like this:
SqlCeConnection c=new SqlCeConnection("Data Source=\test.sdf");

I am having trouble with SQL Server Compact Edition 3.1 on windows CE 5 on a
PAXAR Monach Pathfinder Ultra 6039 device.
After I have installed it and then try and do this :
Dim CeEngine As SqlCeEngine

We are developing application based on NETCF 2.0 and SQL CE 3.5 for Windows
CE 6.0 R2. Everything looks ok on development machine but when we ship the
app to the real device it raises the error: "Can't find pinvoke dll
sqlceme35.dll".

Is the max number of records in a table(database in the CEDB/EDB world)
0xFFFF i.e. 65,535?
I see in this in windbase.h.
// Max number of records allowed in a single database.

I just upgraded my mobile DBs to 3.0 and CF 2.0 and am now having problems
altering tables.  If I run the sql form Query Analyzer 3.0 or from Microsoft
SQL Server Management Studio the sqls run fine however, if I run it from
within my application it never alters the table and ...

hai...
 Am using sql server ce2.0 in my target device.. and i would like to
copy my database table to other database... by using the following
query but it doesn't work..(following code embedded with evc++  &