Hi, I am using sql server 2005 and ce framework 3.5 and attempting to use merge replication between my hand held and my sql server. I am getting the following error: Error 28532 : A read operation from the transport returned no data. The version of SQL Server Compact 3.5 Client Agent and SQL Server Compact 3.5 Server Agent should matc...
I have a SQL Mobile database with one table. It has several columns with useful, often queried data and one column that stores a relatively large string per record (1000+ characters) that is not queried often. Imagine this fake schema, the "lifeStory" field is the large one. table1 String firstName String lastName String address String...
I need to have my installer include the .NET Framework 3.5 SP1 as well as SQL Compact 3.5. I remember seeing a place somewhere in the Visual Studio IDE where these could be included in the install, but I can't find them. Does anyone know how to do this? Thanks! ...
We have an application that will be collecting data and storing it in local WinXP PCs using Microsoft SQL Server Compact. We want to aggregate that data up to a single full-blown SQL Server for reporting and archival. The data transport needs to be fairly continuous (i.e. not batched) though some latency is acceptable (a minute or two ...
I am trying to run an application that normally works when I install on XP, but it doesn't work when I install it on Vista. I am installing the prerequisite of .NET 3.5 SP1 and SQL Compact 3.5 included as part of the install but I still get this exception: Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Ex...
I am trying to serialize an object to a sql compact database. I am using VCS Express 2008. Every time I run a test to see if my data is sent to the database, nothing is in the database. My code: string inputForDB = null; QuizCategoryTableAdapter quizCategoryAdapter = new QuizCategoryTableAdapter(); Qui...
Normally I use SQLite databases to store data for an application on a per-user basis: I include a blank version of the database in my app and copy it to the user's app data directory on first run, and that's where I keep all their personal data related to the app. Is it possible to do the same thing with SQL Server Compact edition? I th...
Does the silverlight clr support access to a sql compact database placed in the silverlight application's isolated storage? If so, any pointers to code samples. I would like to cache information retrieved from the server in previous sessions. ...
What is the fastest way to fill ComboBox in C#? With Add() Bind the ComboBox to Dataset Or there is a faster way ? Thanks. ...
I've created a table in Microsoft Sql CE that I'm using to hold some data. I've generated an ORM via SqlMetal and I've pulled the datasource into my WPF project. I want to create a simple WPF form that can be used to edit a record in the table via the ORM-generated classes. I want this form to support typical OK/Cancel semantics. I'v...
I want to access Microsoft SQL Server Compact Edition databases from Java. How can I do that? I searched for JDBC driver for SQLCE, but I didn't find any. ...
Using the Access Database Synchronizer has anyone been able to synchronize with an mdb stored in a network location? It doesn't even work if i map a network drive to my local c: i.e. c:\test.mdb works but z:\test.mdb doesn't. I simply get a System.Data.SqlServerCe.SqlCeException "Failure to open SQL Server with given connect string." ...
Keeping performance on a mobile device in mind, what do you think is the best approach with an SQLCE Connection. Keep it open for the duration of the application or let it close whenever a call to the database is needed. Obviously this depends a little on the nature of your application however I'm curious to hear what the group has impl...
I am noticing something strange happening. I'm porting an application to work with Sql Server CE 3.5, and finding something strange happening. What i'm seeing is that an insert will fail (violating the primary key constraint), and will keep failing until I use Visual Studios Server Explorer and open the table with the Show Data function...
I'm developing a C# application on Windows Mobile, and like most of my WM applications, I always get bogged down whenever I'm deciding on a serialization strategy. In the desktop world, I'm not too worried about it because i've already developed a pretty robust custom xml serializer - however, in the WM world, I don't want to use it be...
I'm working on an application that runs on Windows Mobile 6 that needs to be able to retrieve all items from an item table that contain a given string (provided by the end user) within the item's description field. The problem is that there are approximately 170,000 items in the table. Since I need to return all items that contain the st...
Hi everyone I work with DB (SqlCe) in WinCE (C#) After search and insert of 300 records, the terminal start to work very slow What can I do to make it faster? Can I have a little sample? Thanks for any help ...
Hi. I'm using following for a simple database application: SQL Server Compact Edition .sdf file as database, with int primary key IDs. Typed DataSet and BindingSource as data access layer DataGridView for displaying data. My problem is, I'm having trouble with the last inserted record/row ID. When I add a row to datagridview, using A...
The application I want to build using MS Visual C# Express (I'm willing to upgrade to Standard if that becomes required) that needs a database. I was all psyched about the SQL Server Compact - because I don't want the folks who would be installing my application on their computers to have to install the whole of SQL Server or something ...
Does it make sense to use SQL Server Compact for a desktop application? How much data can it handle? Is it possible to use it with multiple users? What are the constraints? What happens when database files are broken? Is it possible to programmatically recover or would it be easy to solve the problem remotely? ...