msmobiles.com - Practical introduction to SQL Server Mobile

Catalog > Windows Mobile software development > Practical introduction to SQL Server Mobile

Practical introduction to SQL Server Mobile

Since SQL Server Mobile 2005 is coming soon also to smartphone, not only to Pocket PC, and it will be embedded in ROM of both these platforms, then maybe you could find it useful to learn more about it and how could you use it.

To play around you need (yet) Pocket PC PDA or Pocket PC phone, because Microsoft has not released SQL Mobile Server 2005 but the latest version available is called "SQL Server CE Version 2.0". Just go here, select your language (or English) and click Go, then run Setup.exe after downloading and move files from C:Program FilesMicrosoft SQL Server CE 2.0DeviceArmSa1100 to some folder inside of your Pocket PC.

Then tap, with file explorer inside of Pocket PC on dllregister.exe file.

Then open file isqlw20.exe and observe something like that:

... or rather no, at first you will see nothing, just "Databases" so you need to create new database - just top on the icon when selection is on "Databases" and "Connect to SQL Server CE" dialog will appear, then click "New Database" button and then by selecting other places in the tree and using icons create table(s) so that you have someting like above on the picture.

Then switch to "SQL" tab and enter "insert into things (id, name) values (1, ´smartphone´)" and execute it again with icon in the toolbar on the bottom.

Then type "select * from things" as on the picture here:

Execute it and observe in "Grid" tab this:

... and you can take a look at "Notes" tab too (it´s like "Console" that shows errors):

You see how easy it was? In literally 15 minutes you can have FREE FREE FREE database server running inside of your Pocket PC! Yes, you can even put data in it and store various information!!!