DB Engine - SQL Server CE

Thread preview

Thread	Last Post	Replies

Subscription expiration time is NOT respected by SQL CE 2.0 subscribers	30 Jul 2009 20:28 GMT	4
We have an installation of about 100 Windows Mobile 5.0 Pocket PCs all equipped with SQL CE 2.0 database and a Microsoft .NET Compact Framework 1.0 SP3 application written in C#. The application frequently initiates Merge Replication to a backend
SQL CE 3.5 and Data Loss on SD Card	30 Jul 2009 15:26 GMT	15
We have an application running on a hand device that utilizes SQL CE 3.5 for data storage and retrieval. The database is resides on a 2 Gig SD card. We are seeing ocassional data loss after the device is powered off and back on in the field. In testing we cannot reproduce the ...
How to create .SDF file programmatically on the server for MR	29 Jul 2009 17:30 GMT	6
We have an SQL CE 2.0 .SDF file that gets generated for the first time after a successful Merge Replication process against a SQL 2000 SP4 database. The size of the .SDF file is about 18MB and our Windows Mobile
Is Windows 2000 definitely not supported for SQL Server CE 3.5 SP1?	27 Jul 2009 05:35 GMT	1
I'm trying to write up the system requirements for a package I'm developing, and have just tested my software on Windows 2000. It seems that despite being allowed to install 3.5 SP1 on a windows 2000 machine with no errors, when I try to check if it's installed using this
SQL Compact 3.5 + Compact Managed 2.0 ???	24 Jul 2009 13:14 GMT	7
I'm upgrading a platform to use SQL Compact for CF3.5 We previously included all the files manually, but I've upgraded everything I can find and removed all the manual file entries. All the dlls seem to get copied to the image fine.
SqlServer 3.1 and 3.5	22 Jul 2009 05:56 GMT	1
I have a desktop application created in VS2005 using SqlServer 3.1. I created a copy of that project and opened it on a different pc that has VS2008 and SqlServerCe 3.5 only. The sdf that the copy on VS2008 created was infact a 3.5 database . I know this because I sent it to a ...
How to DROP index with Unique constraint?	22 Jul 2009 05:55 GMT	1
What seems to be an easy task is giving me some major problems. I'm trying to drop an Index with Unique constraint in order to recreate it, but for the life of me, I cannot do it. The documentation indicates that a simple DROP INDEX statement cannot be used on Index
Can I do a mail merge in Word 2007 or get data in Excel 2007 from an SQL Server CE 3.5 database?	21 Jul 2009 11:24 GMT	1
If so, I can't for the life of me figure out how. I go to select data source, then choose New Source. After that I choose other/advanced, then choose Microsoft SQL Server Compact OLE DB Provider 3.5
Getting information about users that make logon to SQL SERVER	16 Jul 2009 16:29 GMT	1
I've to write a procedure that retrieves the login times of a specified user and an indication if he is in a login status I would like to know which system's procedures/functions/
Nested select ...any help ?	16 Jul 2009 10:33 GMT	1
I'm trying this "select count() as Column1, (select count() from Table1 where Table1.Cond = 'X' and Table1.column3=alias1.column3 ) as Column2,
Getting data about users that make logon to sql server	16 Jul 2009 10:19 GMT	1
I've to write a procedure that retrieves the login times of a specified user and an indication if he is in a login status I would like to know Which procedures/functions/views
Unable to enumerate changes at the DBServerSyncProvider	14 Jul 2009 17:54 GMT	1
How can I trap this exception only? I know how to trap exceptions but can't trap this particular exception only?
private Deploy of SQL CE 3.1	07 Jul 2009 03:20 GMT	16
Since there is no catalog item in "platform builder for windows ce 5.0" for sql compact 3.1, I would like to just copy the necessary DLL's to my application folder and run from there. I would also like to stay away from installing the provided cabs. My question is will it be ...