I developed a database app WM2003 project that runs smoothly, but when
I install it in WM6 devices, everything seems to be OK (the
application runs) until I try to create a SDF database. Then this
message pops up

I have been trying to get merge replication to work between a Windows CE
device with SQL Server Compact Ed 3.5 and SQL Server 2005. I have made good
progress but got stuck with an error that Google can’t help me with. Firstly,
I will discuss my progress for those who might hope ...

Microsoft SQL Server Compact Edition V 3.5
When I send this SELECT string:
SELECT Shape_ID FRADDL FRADDR TOADDL TOADDR FROM roads_WI
in this code fragment:

I added a call in my C#.net program to do a CompactDatabase on the handheld
device.  When I tested it, it turned my 2.5MB database into an 11.1MB
database.  Below is my code:
string connString = "Data Source = 'myDB.sdf'; Password = 'PWD'; Encrypt =

I had *just* completed writing some detection code for SQL CE, but
then I installed SP1 on my device and it uses a completely different
registry format for version information.
Here's the old format, dating back to at least 3.0 -

Is there any way to rename a column once it has been defined and saved?  I
looked into sp_rename but it is limited to table names only.
Regards,
Rob C

I've been using SQL Profiler to look into why my MS SQL 2K server has been
running slow.  I've found a number of results from different applications
where the TextData is null and the Duration is high.  I can determine that
they are comming from applications I've written because ...

I have an eVB application with SQL CE 1.0.
This application makes some data updates using "Update"-statements
(Update Patient Set PT_BEFRAGT=0...)
I read that SQL CE 1.0 doesn't support the Update command.

I have a .net application using SQL Compact 3.1, suddenly we started to get
an exception saying "Operating system does not support encryption (SQL Sever
Comapct ADO.NET Data  Provider)
Any advice

after using the CE 3.1 database for quite a long while without so much as a
hitch we have now come accross a serious-looking problem, hopefully someone
here can help us. Our native C++ application uses four CE databases, two of
which are likely candidates for vacuuming operations ...

I've got SQL CE 3.5 installed on my desktop, and am trying to get the data
into excel 2007.
I'm trying to do this by going to the data section of the ribbon,
then selecting from other sources,

We have a client server product using SQL Express/Microsoft SQL Server
as a backend. we have a lot of StoredProcedures we use in the product.
We are now planning to create a low end version of the server product
which can run off a device running Windows XP Embedded. So i have

Is there a file format specification available for SQL Server CE v2.0?
I'm having an issue with an SDF file (I can't open the database because of a
FILE SIZE error in the header). I'd like to know what the format of the header
is to see if I can fix the problem. I've looked for a ...

I am not new to SQL and using SQL queries, however I am new to Windows
CE and using SQLCE 3.5. I have so far managed to install it and I can
add it to my operating system using platform builder and the component
catalog.

Is it possible to connect from a console application (C#) running on the
desktop to a CE SQL Server database on a Pocket PC when the device is
docked?  If so what would a typical connection string look like?
Thanks in advance