I have one table that I can't push to the central database with SQL-CE.  I
get an error message saying the table does not exist even though I can look
at it with the query analyzer, so clearly it does.  Every other table pushes
correctly using the same push routine.    I'm trying ...

Hello everyone.  I'm trying to create a table in a SQL CE 2.0 database using
Isqlw and am getting the "errors in command" message.  Can someone please
tell me what is wrong with this?
CREATE TABLE "tblCase" ("CaseID" int IDENTITY(33,1) NOT NULL, "ClientID" int

Are there any reference that list all devices that support SQL Server CE?
Thanks in advance,
Leila

Can somebody help please - i keep getting this erro when trying to sycn
up my emulator to my Merged Replication DB. When i look into he error
message via the VS debugger i can see this text in the SqlException
error:

I'm trying to use ADOCE to read a  SQL CE (more specifically, SQL Mobile)
database on the the Device Emulator.  My problem comes in creating the
initial
database connection.  I keep getting the following error:

Which is the problem of transactions in SQL Server Ce 2.0 ?
Why says Microsoft that SQL Server Mobile really works with transactions ?
Regards

in my application, I get a native error 0 sometimes.
We wrote a VB.NET application which holds its data in SSCE2.0 on a
WinCE.NET4.2 device. The database's size is about 800kB to 1MB, there are a
lot of inserts and updates, sometimes deletes. A certain SQL command seems to

For the same database=192.x.x.x\c1256 I use both RDA and SqlClient for data
access.
Using RDA i can pull two tables successfully. But when i use SqlClient to
connect to the same database i get error=> PlatformNotSupportedException.

this is my Scenario
lets say i have two mobile devices with device ID A and B. both of them have
a patient tabel where data is pulled from SQL table with tracking on using
RDA. the patient are inserted at mobiel device end only for the first phase.

I have faced the above error for the first time a few days ago.
The configuration that I use is SQL Server 2000 Windows CE Edition 2.0 SP4
and Compact Framework 1.0.5 on the device and SQL Server 2000 SP4 on the
desktop computer.

I'm trying to build an app in vb.net  & sql mobile 3.0 for storage.  I'm
sync'ing with the server using a soap service (since I'm not using MS SQL on
the server), however I can only do this two or three times before I get an
error on inserting a row using a table adapter:

Hello....
We have an app that uses SQL Mobile....that will allow multiple
subscriptions and connections to the client sql mobile database.  We are
looking at allowing the user to save data and while they continue to work, to

Hello...
Does anyone know if we can, within our .Net CF app on the mobile device
(using SQL Mobile), detect if a row or table is locked during the replication
process and then issue a re-try if so?  I am under the impression that the

Hi;
   I have a pocket pc app that allows users to select a date. The selection
is in a string format; example: 08/21/2005. When I try to update the
database, the date is put in as 01/01/1900 00:00:00. My SQL code snippet is:

I've found a bug in my application that crashes when an apostraphe is used
in a field. For example, "SELECT * FROM USERS WHERE NAME='M'Macdonald'".
Obviously because the text value is encoded in quotes. Is there a way I can
make it possible to execute queries with apostraphes in ...