I am the newbie in the mobile application environment, wanna know few
things... I searched google but got confused by looking at so many things.
   I want to write a application on handheld, which makes a simple entry in
SQL SERVER CE.

I have copied the MSDN example, verified that sscesa20.dll was correctly installed and I'm getting:
An incorrect or unsupported HTTP function call was made.
here is the code:
rda = New SqlCeRemoteDataAccess

Ok, so I set up merge replication, got a table out to the client (iPaq w/
Windows Mobile 2003, compact framework), updated it, and am now attempting to
replicate changes back to the back end.  The table that I'm experimenting
with has an insert/update trigger on it to keep anyone ...

In my application i am creating the sql ce db in the same folder of my
aplication, and then i am using it in the application as if it is in that
folder.
Now imagine a user moves the db file to another location, then the

A table in SQL CE contains a column (integer) composing the PK.
When I execute a SQL Query like :
SELECT * FROM MyTable
I get the data, but the column composing the PK are not ordered:

I'm developing a small C# app with VS .NET 2003 and SQL Server CE 2.0 for
Pocket PC 2003. I am building a SQL script having several "INSERT INTO"
statements, which I read & execute line by line. Usually it runs ok, but
sometimes occurs an error "25002 The specified buffer size is ...

When I try to access http://www.microsoft.com/sql/ce this message is
displayed.
HTTP 500 - Internal server error
Internet Explorer

I am getting this error from a lot of users on one box - from about 6
publications on that box so I presume it has something to do with the
sscesa.dll server agent.
I have posted a question regarding this a few days ago.  Could this be

Is it possible to delete old .IN and .OUT files?  I have about 3.2gig of
them and some of them are pretty old.
Also in enterprise manager is it possible to delete the deactivated
anonymous subscriptions?

I have two questions about sdf file encryption. :
- Is there performance loss ? How much ?
- Is it possible to change the password ?
Thanks,

Ho do i storage a SQLCE Database on my PocketPC?
In RAM? If i have a WARM boot??
In Storage Card? But the storage card can corrupt, is slow and decrease
performance!!

Is it possible to use the cast function in sql server CE ?
ie. if my command text was
Select cast(somefield as nvarchar(15)) as ColName from sometable
I get an error complaining that sql server CE can't parse the query. Of

We have built an application based on Sql Ce Merge Replication.
The initial replication (subscription then synchronization) fails after 3
hours and near 80 MB copied to the disk.
Is there any time limitation of a synchronization?