locked
Sync SQL database on PocketPC in VB RRS feed

  • Question

  • Hi,

    I'm doing an application in VB 2008 for a PocketPC (Windows CE 5.0) that will collect data and store them in a SQL Mobile database. Data have to be sync with a SQL Server 2008 R2 Express on a host computer throught WMDC (Windows Mobile Device Center). Host O/S is Windows 7 Pro 32 bits.

    How can I do that? what is the best practice?

    thanks for your time and help

    • Moved by Jie Bao Monday, January 17, 2011 5:03 PM (From:Visual Basic Language)
    Friday, January 14, 2011 2:41 PM

Answers

All replies

  • Hi,

    This could be acomplished by SqlCeRemoteDataAccess:

    http://www.codeproject.com/KB/windows/PocketPCwithSQLCE.aspx

    Thanks

    Binze


    Binze Zhao [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by Bin-ze Zhao Friday, January 21, 2011 7:23 AM
    Thursday, January 20, 2011 7:22 AM
  • Hello Dominic,

     

    For data sync in PPC and Desktop you can refer below threads which is already discussed for the same.

    1) Thread - 1

    2) Thread - 2

     

    Hope it helps.


    - Pavan Pareta [MCTS - Windows Mobile 5.0] If you find my post is helpful for you then mark as a answer and vote it.
    • Marked as answer by Bin-ze Zhao Friday, January 21, 2011 7:23 AM
    Thursday, January 20, 2011 7:45 AM
  • thanks for the replies.

    I'm trying to setup a RDA connection but it doesn't work. IIS is setup, Virtual Directory is setup, but when I call the Pull method, I get an error stating the SQL Server is not found (although the connectionstring is correct).

    any idea would be appreciate

    thanks!

    Friday, January 21, 2011 6:15 PM
  • ok, connectionstring was not correct. I got it working with the following string:

    Dim

     

    connString As String = "Provider=SQLOLEDB;Data Source=localhost,49446;Initial Catalog=DBTest;Persist Security Info=True;User ID=username;Password=abc123;"

    RDA Pull and Push method now works fine. thanks for your help!

    Friday, January 21, 2011 7:29 PM