Hi experts!
IDE: VS .NET 2003
OS XP pro
Microsoft SQL Server CE 2.0

i'd like to read data out of a text file directly into an SqlCe database.
The textfile is something like this :
1;0;parent1;
2;0;parent2;

which steps are necessary to generate a database file for the SQL Server
mobile edition (*.sdf) from any database (Access, SQL) on a host PC without
the need of having a Windows CE system running ? This should be possible from
SQL Server 2005 Management Studio.

Problem 1: I am getting some error "Error Message: Exception" while disable
the input panel in one form and opening another form.
In case if i enable Controlbox=true then i am not getting this error.
Problem 2: I navigate from one form to second form with key board enabled in

With the new versions of SQL Server, Visual Studio and .NET Framework it
should be possible to create SQL Server CE database files on a desktop PC
(right?). I am trying to read-up on this but can't seem to find a good page
for doing so.

I appear to be confused as to how merge replication works.  We have some
handhelds that sync to a sql server 2000 database.  The expiration was set to
14 days which turns out to not be long enough.  When one of those units syncs
they get a sql ce exception saying that the sync ...

is there a method or property of a class that will
return a GUID in VB.NET that I can use as
the PK of my DB.  I do not want SQL to generate
it as I can not then use

I want to desing my database in my Desktop PC for a PDA
I have installed SQL 2000 Personal and IIS 6.0 .
When I try to install  SQL CE  the system show me you don't have
compatibility between sql and sql ce

Can I perform the standard SQL replication on a Windows Mobile 2003 device
using SQL CE against a SQL MSDE installation? Or do I need the full SQL
server for this?
John O.

Hello experts!
I'm a programmer, and now interested in developing an application for pocket
pc. So I've searced microsoft.com for downloads of MS Sql Server CE, only
found a version for unmanaged code.  (This version is not for .NET Compact

Is it just me or is RDA not a good choice when you have multiple devices?
For example if you pull data down with two pocket pc devices and device one
and two make 1 new record each. Then device one pushes it's changes back to
the server, which is fine. Then device two comes along ...

Is it a significant performance impact to add a second order by field?
I.e. if I have
select * from table1 where f1 = 'blah' order by f2
select * from table1 where f1 = 'blah' order by f2, f3

the scenario is.
pda with our application running on it that connects to a sql server
database on a pc. the connection is made via sqlce and iis and is on an
802.11b network. pc is an xp machine and running kerio firewall.

Hi...I posted this message earlier...but I have some new info.
Basically, here is the problem...I have created 4 different Merge
Publications on our SQL2K server.  If I run the merge replication from my
.Net app, the first one (whichever one doesn't matter) ALWAYS works.  The

Hello...
I have a method in my .Net CF app that currently replicates data from our
SQL2K server.  I created three distinct publications...so that the user could
decide which data that they want to synchronize...or pick all....and when I