Channel 9

Entries:
Comments:
Posts:

Loading User Information from Channel 9

Something went wrong getting user information from Channel 9

MSDN

Activity Profile

Latest Achievement:

Loading User Information from MSDN

Something went wrong getting user information from MSDN

Visual Studio Achievements
Visual Studio Achievements

Latest Achievement:

Loading Visual Studio Achievements

Something went wrong getting the Visual Studio Achievements

Rory Does Windows Mobile Development - Data Synching With RDA: Part One

Embed code for this video

Copy the code above to embed our video on your website/blog.

Close

Video format

Option selected may change based on video formats available and browser capability.

Close

Download

How do I download the videos?

  • To download, right click the file type you would like and pick “Save target as…” or “Save link as…”

Why should I download videos from Channel9?

  • It's an easy way to save the videos you like locally.
  • You can save the videos in order to watch them offline.
  • If all you want is to hear the audio, you can download the MP3!

Which version should I choose?

  • If you want to view the video on your PC, Xbox or Media Center, download the High Quality WMV file (this is the highest quality version we have available).
  • If you'd like a lower bitrate version, to reduce the download time or cost, then choose the Medium Quality WMV file.
  • If you have a Zune, WP7, iPhone, iPad, or iPod device, choose the low or medium MP4 file.
  • If you just want to hear the audio of the video, choose the MP3 file.

Right click “Save as…”

In this screencast, I walk you through the most difficult part of synching data between a Windows Mobile device and SQL Server, which, oddly enough, isn't actually the coding.

It's the setup.

We'll download the tools, and then configure all the bits that need configuring.

In Part Two, I show you how to sync data using RDA (Remote Data Access).

I hope this finally satisfies all the people who have been asking me for an RDA session Smiley

As always, you can read about my day job here, or visit my blog here.

Screencasts In This Series:

- An Introduction To Windows Mobile Development

- Building a Simple Web Browser With the .NET CF 2.0

- A Simple Data Driven Windows Mobile App Using SQL Server Mobile

- Data Synching: Part One

- Data Synching: Part Two

- Windows Mobile 5.0: State Notification API

- Windows Mobile 5.0: Pocket Outlook Object Model

- Windows Mobile 5.0: Camera API

Tag:

Follow the Discussion

  • jasonmogjasonmog
    The only problem with this is that the connection string Provider=SQLOLEDB;Data Source=192.168.1.101;User ID=mobile;Password=password;Initial Catalog=infopalpos does not work. The same connection string works on the host locally. The sqlcesa30.dll can be accessed from internet explorer on windows mobile. What gives?
  • lichecalicheca
    Hi.

    I follwed the steps of the Configure Web Synchronization Wizard, and it works well when I access the SQL server Mobile Agent on my local machine throught Internet Explorer.

    The problem comes when I try to access it from my pocket PC, which is connected to my wireless network, it doesn't work. i know I'm connected because I can access shared folders on my local machine from my pocket PC.

    Funny thing is that if I turn off the wireless adapter on my pocket PC and then place it in the cradle works fine.

    Can anyone help figure this out.

    Thanks.

    Carlos
  • skylancerzskylancerz
    Hi,

    I faced an error when I tried to install SQL Server 2005 Mobile Tools...
    It prompted me to install SQL Server 2005 Replication Component, but in fact I had installed the components in my machine earlier...
    So, any solutions for this problem?

    Thank you Smiley
  • BishopBishop

    Licheca


    Im not sure if your question was answered but there could be a couple of things wrong with this.

    1. IP address, DNS and subnetmask have to be the same or the connection will fail..
    or
    2. your Firewall is on.

    I would start by going into your mobile device internet browser and type in the url to your desktop. ex. http://192.168.0.100/sqlce.sqlcesa30.dll and see if the mobile browser can hit that dll. If not then try using the host name instead of the IP. Like this http://DELLDESKTOP/sqlce/sqlcesa30.dll . If all fails check your IIS confiuration or just create a PEER-TO-PEER connection with static IP's. Hope this helps.

  • chaukse_rahuchaukse_rahu chaukse_rahu
    Can u please take one session on Mereg Replication

    I am using SQL Server 2005 and SQL Server 2005 Mobile Edition
    with VC# 2005

    in which I am using Merege Replication

    Actually their are few problems with Merge Replication

    I want to do Basic Operations on a particular table : like Select, Insert, Update, Delete

    out of which I was able to do Insert and Select operations
    in these my .Synchronize() function works very fine


    now i want to Update a single record from a Particular table

    I have written a code, in which it does updates with DataSet
    but when I use Synchronize() function to sync the SQL Server Data with my local Data from device
    nothing is happened, no change in Server Data


    So it will be great help to me if u take one session on Mereg Replication with all basic operations and few sample codes in screencast


    thanks
  • monstmonst

  • monstmonst
    Fixed it!
  • davedave

    Hi Rory,Thank you for the two videos about RDA.If the IIS server and SQL Server database are on different boxes (not on same machine), how to do set up or specify URL for sqlcesa.dll and database?I am develop a mobile app but IIS computer and SQL server computer are not located on same machine. Please help.

Remove this comment

Remove this thread

close

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.

More posts in this blog

See More

Related posts

Creative Commons License

© 2013 Microsoft. Except where designated as licensed by
Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 License,
Microsoft reserves all rights associated with the materials on this site.