Making the Step from embedded VB to .NET CF and problems with databases

[=?ISO-8859-15?Q?Andr=E9_Rode?=]

Hi there,

I've got a general question. We're a small firm, developing database
software for PocketPC 2002 till Windows Mobile 5.0. Our customers got a
Mircosoft Access Application which is interacting with a CDB Database on
a PocketPC. Works well, even with Windows Mobile 5.0. The only problem
is the cancelled support for converting MDB to CDB files with ActiveSync 4.
Okay, so we say "Let's go future". But this comes a complete cut to our
old system of data exchange PC to PocketPC and vice versa.

So my question: What possibilities are there for us to make a smooth
exchange to our customers? A new software installation (the .NET CF
application) is the smallest part.
What about the data exchange?

CDB is not supportet, none of our customers got a SQL Server running.
And it should be no alternative that a SQL Server 2000 should be set up
- together with the IIS for exchanging with SQL ServerCE, that's a no go
for us.
Is there a way to create the SDF files on the desktop?
Or what other ways are there?

Sorry for my english, but greetings from Germany
Andre

 

[João Paulo Figueira]

Hi Andre,

Take a look here: www.primeworks-mobile.com. You will find tools to remotely
access SQL CE / Mobile databases from the desktop and we are starting to
publish the first samples of the new synchronization product (software
component for .NET, VB6 and C++). With it, you will be able to replace the
old sync solution and upgrade to a muche better device database.

 

[chris-s]

Don't feel you have to use full SQL Server, the MSDE (desktop edition)
works just as well and suits many smaller end-users and IIS is shipped
with XP Professional, so depending on business size you don't need to
have a full blown server, a basic XP Pro machine may suffice. Using
these standard Microsoft apps with the SQL ServerCE makes data comms
extremely simple to setup and use.

Chris

 

[=?ISO-8859-15?Q?Andr=E9_Rode?=]

Hi Andre,

Take a look here: www.primeworks-mobile.com. You will find tools to remotely
access SQL CE / Mobile databases from the desktop and we are starting to
publish the first samples of the new synchronization product (software
component for .NET, VB6 and C++). With it, you will be able to replace the
old sync solution and upgrade to a muche better device database.

Oh thanks, this looks great!

Do you even know a possibility to set up a SQLServerCE on a device with
littlest affort? Most of our customers are experts in everything else
but PCs. Making a click for an installation, that would be fine..

Greetings from Germany
André