I just upgraded my installation of SQL Server 2005 Express to SQL Server
2008 Express. When I try to open one of my Sql Compact Edition 3.1 databases
I'm asked for the database password so that it can't be converted to 3.5. I
don't want that! Is there anything I can do to avoid ...

For test, I installed SQL Server Compact 3.5(or 3.5 sp1) for Desktop.
But in the installed path, I couldn't find isqlw35.exe
How can I get it?
Thanks in advance.

I have a Windows program developed in VS2005 using SqlServer CE 3.1.
Because of speed, I keep a shared static connection open to a database
that is frequently read.  During periods of inactivity, a new copy of
the database is copied over writing the previous copy.  I first call

Actually, what I want is less help please.
If I enter SQL into the SQL Pane of the Query Designer and execute, the
designer helpfully reformats my text for me.
I would really prefer to keep my original formatting.  Really and truly.

I want to insert data into a new table using another table data , THe new table got 04 fields. I want to refer one table to get data for only 02 fields and another table to get data for other 2 field
From http://www.developmentnow.com/g/97_2005_12_0_0_0/sqlserver-ce.ht
Posted via ...

i want fill SDF file from PC . i tried it from mobile but its too
long.  i use sql ce 2.0 Can i fill sdf file from PC?

when I create a CE 3.5 SP1 Database with SQL Management Studio i can open the .sdf with the SQL Management Studio, but
there is an error if I try to connect from the VS 2008 SP1 Server Explorer (The error states that the db has been
created with an older version of SQL Server ...

SQL Server CE 2005, Visual Studio 2005, C#
I have a windows service that I wrote that runs under the Local Service
account.  I cannot connect to my SQL Server CE database.  Every call to
_dbConnection.Open();

Okay, I did something to screwup my system. I think that it may have
been the VS2008 beta a long time ago, but I'm not sure but I am just
starting to need CE.
I cannot connect to a CE 3.5 sdf database with VS2008. I can open the

I've written an application for inventory and price enquiry. The application
is written in c# using VS2008, .NetCF2.0 and SQLCE3.5. The device where the
application must run is a Symbol/Motorola MC1000 which has very poor
performance and very little memory.

I wanted to have the genereic |DataDirectory| token in the
connection string so that at deployment time I do not need
to know where the application is. When debugging, I saw in text visualizer
that my connection string was :

I have a new problem with SQL CE 3.5 SP1 that I did not have with 3.5.  Now
my Pocket PC programs can no longer run on XP.
Is this a new SP1 feature?  Guess I need to write real desktop apps to
manage the data.  It was nice while it lasted to use the same app on both

  Can I use SQL server CE 3.5 as the data source for LINQ to SQL?
I am getting the error that the data source is not compatible!
Regards

We are getting into the world of SQL Server Compact 3.5 now. :)
But, because we don't have VS2008, needed to use VS2005.
WinCE 5.0 emulator with included default os image is being used.
We tested deploying it under VS2005 with setting the path of

I made an application that make a lot of big insertion in a 3.5 CE database.
After each insertion the memory used grows up.
If I open the db before each insertion and close the connexion after, it's ok.
But I don't want this. Is there a way to "flush" the db from memory to disk