How to read SQL Server 2008 via wifi with a handheld with Windows CE.

Posted on 2011-10-14
Last Modified: 2013-12-27
I have an intermec handheld with windows mobile 6.x, cfw 2.0 and wifi. I'm programming it with vs2005 without problems but I need to read and write a SQL Server 2008 database via wifi. What do I need to install in order to support it? There is not namespace in my development environment.
Question by:BemboX
    LVL 6

    Assisted Solution

    The solution is combined of two parts, client and server:

    1. Develop an ASP.NET Web Service on the server side that will communicate with the database and expose SOAP operations like QueryTable1, UpdateTable1 etc.
    Refer to MSDN -

    2. Develop a Windows CE client with Web Services proxy using the "SOAP Toolkit for Windows CE"
    Refer to MSDN -
    LVL 16

    Accepted Solution


    you need to install SQLCE in your development envrionment (Visual Studio 2003/2005/2008, no a express edition, not VS2010).

    I assume, you already instaled a windows mobile SDK: either Windows Mobile 5, Windows Mobile 6 or Windows Mobile 6.5 DTK). System.Data is ADO.Net classes and runtime and should be available after install of windows mobile sdk. It is not part of SQLCE/SqlCompact.

    There is a good book which has several chapters for SQLCE: Programming the Compact Framework.

    With SQLCE, you can connect to local (on the device) sql databases and to remote ones (for example a SQL Server 2003). Needs System.Data.SqlServer or System.Data.SQLClient.

    ASP.NET and SOAP is another way to connect to SQL Servers.

    With a SQLCE Client Agent on the server side you can even have a local database and push and pull changes using Replication. But this is also described in detail in the above book.

    Using SQLCE to connect to a SQL server is easy, just use the right connection string. As you have WiFi, you may use this direct approach.

    LVL 83

    Expert Comment

    I am not sure about VS2005 but in VS2008, You can use the System.Data namespace (you may have to add reference to it). All you have to do is make sure the SQL Server is reachable on the WiFi.

    Author Comment

    I'm going to test this weekend, thanks in the meantime.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (…
    Preface: This article is part of a series focused on cross platform mobile app development (specifically Android and iOS) using the Alloy framework and Titanium Studio made by Appcelerator ( This article presumes a wor…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now