I have a server with SQL Server 2000 installed on it. I have created a
tool that runs on a Pocket PC with SQL CE backend. Multiple clients would be
using the tool on diferent Pocket PCs. I would have to use Merge Replication
for synchronization and since the Pocket PCs ...

I have to write synchronization beetwen pocketpc (sql server ce 2.0) and sql
2000. I know how to do it, I've already written it. I checked Merge
Replication and RDA.But I have one problem and I don't know how to resolve
it. I searched on google, on news groups but I didn't find ...

Hello All and happy 2006 :)
I would like to ask if it is recomended to use both RDA , for some
tables and Merge Repl. for others. The reason I am asking this is for
saving space on the pocket pc.

I'm using SQL CE 3.0 and trying to create a simple insertion statement.  
When I try and run the query the following error occurs.
The data was truncated while converting from one data type to another. [
Name of function(if known) = ]

Using ADOCE
this is a part of the line we use in our connection string
Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=....
What was the provider string to use adoce and SQL server mobile (2005) ?

This is my database connection string, using temporal database
tecnique:
<add key="LocalDatabaseConnectionString" value=" Temp File Directory =
{0}\Database\Temp\; Temp File Max Size = 256; Data

   I am trying to make RDA pull method to get only the changed records to
the PDA.
To achieve this , i plan to pull data that is changed  or inserted after
the last synchronization date to a temp table,  then  move this data to the