I have an Equipment table, with a binary data type, in SQL CE, that I need to
move to a temporary equipment table so that I can perform replication against
that table, and then INSERT the data from the temp equipment tabel back in.
Any suggestions or ideas would be greatly ...

I'm rather new to SQL Server, so forgive me for any stupid questions :)
We've set up an SQL Server (v7) and installed SQL CE (v2) on the clients
(pocket pc 2003). Now we can pull data from the server to the clients using
replication. For this to work we needed to set up IIS. Since ...

I am using PUSH method to sync the changes in SQLCE Database (resides in my
Dell Axim) to Sql Server 2000.
I am having the following problem while doing that.
Error: 80070057

Hello...
I have merge replication setup between SQL Mobile and SQL 2000 and for the
most part it works fine.  However, there are a few instances where I get the
following error:  "The transport read operation returned an incorrect data

Hi All, Im trying to update a new objdataset into sql ce ..
Being encountering this error
system.sqlceexceptio
Can someone kindly advise me whats wrong with my code ??

Is anyone using SSCE2 on CE5? I am trying to do it now and not getting
very far, although initially I tried with ADOCE which adds confusion.
    Set oCat = CreateObject("ADOXCE.Catalog.3.1")
    oCat.Create "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data

Does SQL Server CE need NLS support to be included in the CE image?
I'm guessing it does, because when I try to create a database through
OLEDB I get an error that "The sort sequence is not valid" ... either
with the default or specifically saying LCID=0x0409.

Background:
I'm researching the inevitable transition from .mdb databases to SQL
(preferably standard edition) along with the possibility of introducing
handheld data collectors running WinCE 5, to take place around the same time.

When I initiate a pull from my SQL table I get the error message:
"The table does not have a primary key"
Minor Err: 29010
Thing is, it DOES have a primary key.  I dont get it.  I havnt been able

I'm a newbie to MSSQLServer and to SQL Server CE, so if the following is a
dumb question, please accept by apologies.
Scenario
========

The instructions say that to install SQL Server CE on IIS system if you
are using Microsoft Visual Studio® .NET one has to run one of the
following to files
sqlce20sql2ksp1.exe or sqlce20sql2ksp2.exe

I have developed a.NET CF app for our sales team which uses SQL Server
CE Merge Replication to communicate with the ERP database. The problem
is that our salesteam complain that at times the synchronization is
very slow takes more than 20-30 minutes to synchronize data. The size

i have a problem with instalation SQL CE server. instalation process is not
completely, ended with message:
" SQL Server CE Server Tools is compatible only with SQL Server 2000 Service
pack 1 and higher. ....."

hey all,
I have a very large table (50 Meg) that I need to load into a pocket
PC, and was wondering if the sqlserver on CE comes with a bulk loading
utility (ie: sybase has bcp, and oracle sqlldr, sqlserver == ?).

What I would like to do is to be able to create a SQL Server database on the
desktop PC and 'Push' it to the handheld device.   Can this be accomplished
using RDA?
Thanks in advance