I write an application on VS 2005,SQLSERVER Enterprise Mobile
Edition.Everything is fine.I can make merge replication.The code run in the
Pocket pc.The test section is finish.Now we plan to use the code in
production..

I am trying to copy a table from one database into another, user named,
database. The code I have is not working and I don't know why. Please help.
Thanks

Further to my post -
Orcas and SQL 3.5 Please Explain ?!
I have searched and searched and tried many times but I cannot get a
SQLCE datatable to work correctly even in VS 2005, I am using the

I have an app that uses MS SQL server on the host, all is fine there.  I
need to transfer data to a mobile device.  I'm ok with coding the portable,
the problem is getting the data to it.
Due to certain complexities I can't simply sync tables, the portable

I am developing an EVC application for my reader to access SQL SERVER through
replication.
synchronizing gives the error:
error 1 of 3

Hi, i'm looking for SQL CE 3.5 for Visual Studio 2005. I am currently using
SQL CE 3.1 and wish to use the System.Transactions support which has been
included in v3.5.
I know Orcas includes v3.5 but i need to continue using VS2005. Is there an

Hi, I have compact sql databases which will be local on multiple users
devices. Due to space constraints, for one of the tables i have had to use
auto incrementing integer which works fine for the local database but i
would like to merge all of the users databases into a global ...

Assume there are two tables with each 2 columns. TableA has 3000 rows
and TableB has 30'000 rows and each row of TableA.Col1 is linked as a
foreign key to TableB.Col1. Primary keys, indexes etc are all well
done.

how can I create an index on a table unless it already exists?
In SQL SERVER it can be done through the following sql code:
-----------------------------------------------------------------------------------------------
if not exists (select * from sysindexes

I want to connect to SQL CE database (Server Mobile) using Visual FoxPro. Is
there any driver or something else? Please help me, I am becoming desperate

I am trying to install the Visual Studio SP1 update for SQL Server CE
(SSCE31VSTools-ENU.exe) and get the following error:
The upgrade patch cannot be unstalled by the Windows Installer Servive
because the program to be upgraded may be missing

I migrated an application from  CF 1.0  to CF 2.0, but I'm having
problems using the SQLCE 2.0. Is it possible to use SQL CE 2.0 with an
application compiled in CF2.0?  I don't want to migrate the SQL engine
because there are a lot of databases installed on our clients

on the pocket pc in a merged / replicated sqlce db a delete of 5 rows
takes more than 60 seconds .
... ok the table includes ca. 20000 rows, but for a deletion over the
PK it's still too slow!

Statement select NEWID() fails on database with czech or slovak collation
with following message:
Major Error 0x80040E14, Minor Error 25921

I write an application in pocket pc.Customers make sync(Merge) with
sqlserver.The sync time 26-40 sec generally.The number of rows doesnt effect
the time.I send 200 data to mobile device it takes 15 sec.Mobile device send
1 row to sqlserver it takes 15 sec..