Hello,
When i try to syncronize a replication DB with Pocket to SQL Server 2000 SP2
to SQL Server SE sp2
appears me this error:

Hello...
I created a small prototype app last week that was working great -
replicating data between SQL Mobile on my pda and SQL Server 2000.  Today,
for some unknown reason, the replication process fails on the client.  I

Has anyone of you ran into this problem ?
Were you able to fix it somehow ?
The problem is that, if we call the compact method and there actually
is nothing to compact (regardless og data amount) and the database is

I am getting an error when I try to do a create table and define a column
that is nvarchar(2000).  If i change it to nvarchar(255) it is fine.
I also need to know how to specify 2 columns as the primary key.
Here is my create call:

I am using RDA to download a table of staff records from a SQL Server Db to
my SQL CE database.  My problem is that you have to drop the existing table
first.  If I do that and the download fails for some reason, i have lost the
table that was there.  i could first check for a ...

In VB.net 2003 is there a way to create insert and/or update statements so
that if a string contains a ' or a " that it doesn't screw up the execution
of the statement?
any help would be greatly appreciated.

My desktop C# application working fine with Sybase database. In pocket pc
code i can't access System.Data.Odbc namespace. I think that pocket pc only
supports SQL Server database.
Can anyone give me idea how to access remote Sybase database directly from

Bonjour,
i want to do a query like that:
declare @test int
... -> @test is affected to something there

my problem with sql server, I have a stored procedure that concat text to a
variable varchar(8000), this varible is concat from a cursos, that read
fields of database, my problem is that, this variable truncate string a 4000
and lose the others 4000,

I have a table on SQL Server 2000 sp3 with default values, so when a
new record is inserted and no value is provided for a field , this
default value gets inserted in the field.
I have the table replicated on SQLCE 2.0 (merge replication) but the

Sorry in my last post I forgot to specify the error.
The error is
"A request to send data to the computer running IIS has failed. For more
informatino see HRESULT".

Currently i'm developing a mobile apps(pocketpc) with DB interaction
either locally(sql server CE) or externally(sql server 2000). i intend
to use sql server replication ( merge replication) to synchronise from
Pocket PC to SQL Server 2000.

Hey all,
I am trying to set up our SQL Server and implement RDA for use with mobile
devices, which requires IIS, SQL Server, and SQL Server CE all to work
together.  One of the steps needed is to install the SQL Server CE Server

I want to create a program that works on my pc.
The program will read the data from .sdf file from the pocketpc and
transfer it to sql server 2000.
Pls give me some ideas how to do it?

Please advise whether the sqlce database file be placed outside the main
memory of a pocketpc, say to be placed in a SD memory card.
Thanks