Using SQL Mobile 3.0 on a WM2003 PDA

[PeterNem]

Hi,

I'm trying to create an application which will use an SQL database as a datasource. Both the application and database will be stored and run from a windows mobile 2003 PDA.

For some reason I am having absolutely no luck whatsoever. I've got the database designed on paper, I know what the application needs to do, but I really am falling at the first hurdle. I have Visual Studio 2005 and plan to write the application in VB.net.

I just cannot seem to find out how to actually get the database onto the PDA and once it is there how I get my program to access it. It's the first time I've tried writing a standalone program before which uses a database (I've done stuff with ASP and an Access database before and always found i dead easy) which makes it even more frustrating.

Does anyone have any ideas about using SQL mobile? I've trawled through google search results and it doesn't seem to be well documented at all.

Once I get the database onto the PDA and find out how I access it I'm sure the rest will be plane sailing, it's just this first bit.

 

[voodooflux]

This article on the MSDN might help. It demonstrates a couple of ways of creating a mobile database, albeit with the older version 2.0 of SQL CE.

I'm currently using Sybase iAnywhere on a project, and one of the great features is that the underlying database file can be used with either the mobile or desktop/enterprise version of the database engine.

cheers
v.f.

 

[PeterNem]

That looks like it could be useful, thanks

 

[PeterNem]

A quick update so if anyone else searches for this in the future they may find something useful... I've found a pretty useful walkthrough here:

http://msdn.microsoft.com/vstudio/tour/vs2005_guided_tour/VS2005pro/Smart_Client/DataBinder.htm