SQL CE Query Analyzer and Windows Mobile 6

Data Port Console 


If you are a developer, or ever needed to test, run queries or view SQL CE databases and its contents directly from a Windows Mobile device, most likely you have used or heard about Query Analyzer that comes with the SQL CE SDK.


Unfortunately Query Analyzer doesn’t work in Windows Mobile 6. Fortunatley there are several solutions that do what Query Analyzer does and much, much more.


I have tried Data Port Console from PrimeWorks which is a great tool for querying, viewing and editing SQL CE databases from your PC via Activesync to your device. You can even create new databases on the fly! 


You can access a 30 day trial version by clicking here

Direct CAB downloads

Some of the most handy and usefull mobile websites for Windows Mobile devices are those where you can download and install directly to your device free games and applications.


Unfortunately there aren’t many, but today I leave you two links to try and use in the future when you are on the go:


Smartphone Freeware – for Windows Mobile Standard Smartphones


Smartphone Freeware.com


Link: http://www.smartphonefreeware.mobi


This mobile site is a mobile friendly wm5 and wm6 Smartphones free software directory with some great gps, games, themes, medical, battery and backup applications.


For Windows Mobile Professional and Classic devices you can access:


Freecabs – WM Pro/Classic


Freecabs


Again here you can download free games, ebook, themes and applications for Pocket PC.


Link: http://freecabs.kilu.de/


 

Convert your Pocket PC into a WebCam

WebCAmera Plus 2.o


AtekSoft has just released its newest version of WebCamera Plus v2.0, this new version can now capture no only the image but also audio using your Windows Mobile device.


This great software is still a Beta and free, nonetheless very interesting and supported by Skype.


The new version now supports Windows Mobile 6 devices and ocupies only 537Kb of memory.


You can download the new version here.

NDrive real 3D photo navigation

[YouTube:fTwIRVRRIwQ]


NDrive has released a great and innovative software that allows to navigate in cities using Satelite imagery from various angles making a virtual 3D world.


There are allready several european cities avaliable, and the software is fully compatible with Windows Mobile 6.


You can learn more about NDrive 3D Photo here.

Fiat Blue&Me and Windows Mobile

 


For those of you who don’t know, Blue&MeTM, is the result of the collaboration between Fiat Auto and Microsoft.


Today I took a ride in a Fiat Grande Punto, and saw Blue&Me in action and I can tell you that it’s pretty cool and very usefull.


After pairing you have access to you adress book through the steering wheel controls, answer and place calls with voice commands, and even have your SMS’s read to you!


You can find out more about Blue&MeTM here. And find out wich Windows Mobile devices are compatible here.

Video of the Xperia X1

Xperia X1 


The The Unwired has published a great video of the one of hte latest adittion to the Windows Mobile family: the Sony Ericsson Xperia X1.


This great Windows Mobile 6.1 Professional Smartphone will have some great specs:


  • 3.5G HSDPA/HSUPA
  • WiFi and Bluetooth
  • GPS and aGPS
  • Camera de 3.2 Megapixel
  • Size: 110 x 53 x 16.7 mm
  • Weight: 145 grams
  • Battery: 1500 mAH
  • Processo:r Qualcomm MSM7200A a 528Mhz
  • MicroSD
  • Audio jack: 3.5mm

  • Click here to see the video

    NDRIVE S300

     


    Ricardo Chaves over at PocketPT has tested a very interesting Portuguese brand Windows Mobile Professional Smartphone.


    The NDRIVE S300 has Wi-Fi, Bluetooh, Micro-SD, GPS SIRF III, 2.0 MP Camera with Macro, Li-ion 1200Mha battery, 416Mhz processor, and all this with an excelent price tag: 349€ , arround $557.


    The device is network unlocked and is a GSM/ GPRS Quad Band device.


    You can read more at PocketPT.


     

    Creating a UNC file share and accessing it from Windows Mobile

    Sometimes it might not be safe to carry arround corporate data on your device, but it might be usefull at the same time to be able to access it wherever you go.


    UNC file shares and Sharepoint shares can do the trick because you can share files with you co-workers and browse a directory in your server, for instance you home directory.


    In this article I explain how you can create a UNC file share from a Windows Server 2003, share a file through Outlook and access it via your Windows Mobile device.


    STEP 1: Create a shared folder


    You must first create a shared folder, and then you must go to “Web Sharing” and select the site from wich the folder shoulb be accessible.


      


     


    STEP 2: Create a Virtual Directory


    Afterwards you must go to IIS and create a new Virtual Directory on your website and point it to your newly created Web Shared folder.



    You must also set the correct permissions. These might include, in example the possibility to browse the entire directory and sub-directories.



     


    STEP 3: Sharing and accessing your files


    Now if you have a file you wish to share you must copy it inside the shared folder and create the apropriate link to send to your co-workers.


    When your co-worker recieves the e-mail in the device it should look like this.



    Next thing to do is click on the url and authenticate yourself.



    If all goes well and you have the needed priveliges to access that file, you should be able to download it to your device and view or edit afterwards.


     

    Mobile Device Manager 2008

    MDM logo 


    I have been following closely the launch of MDM 2008 and will be trying it by myself in the near future.


    At the moment there is allready a lot of information on how companies can start managing and securing their mobile devices using MDM 2008.


    If you want to know more about MDM 2008 you can access the following links:


    - Check out the demo


    - Watch the videos 


    - Download the evaluation of MDM 2008


    - Read the guide on how to setup Windows Mobile 6.1 Device Emulators for testing with MDM 2008