Update Data in MS-ACCESS in PC from PPC

Hi all,

I would like to update data in a MS-Access Database which is in the Local IIS Server. I have to update the data from the PPC which is connected to the PC using Cradle.

Can anyone get me some Ideas on this...

Thanks in Advance.
Biju S Melayil



Answer this question

Update Data in MS-ACCESS in PC from PPC

  • thysie

    Hi Manav,

    The PPC is Connected through the Cradle using the NEtwork connection option(Direct Connection).
    when its Connected its able to Browse the websites but its not able to access the Local Host or the IIS Server of the Connected Machine. I checked the Connection Properties in which we havent mentioned any IP Address for the PPC. when i tried to specify an IP to PPC, its not getting connected... Am using BlueBird BIP 3000 Device which has CE .NET 4.2

    Thanks
    Biju S Melayil


  • Alexandre Defalque

    BijuMelayil wrote:

    The PPC is not able to access the IIS Server in the PC as the Active SYnc connection is Created using a Direct connection which doesnt take IP adress for the PPC.

    Not sure what you mean by PPC not able to access IIS. If your PPC can connect to any web-site than it should be able to connect to your IIS. Expose your data as web-service and consume it thru your smart device program.

    Manav



  • j_ames2006

    sounds like DNS issue - its unable to do the necessary routing. Can you connect your IIS using its IP address and not via name

    Manav



  • Corngood

    You can add a data-source to your smart device project and point it to your access database. You can use OLEDB or ODBC connection. You can than create a dataset and use it to modify the data. Please note that dataset performance is not that great on smart device so you want to minimize it's size. Additionally, you need to have device in a cradle scenario to work.

    Another scenario is to expose your data in IIS as webservice and consume the web-service from a smart device.

    Manav



  • rolian

    Hi Manav,

    Thanks for the Reply.

    But iam currently working on Vs 2003 and not in Vs 2005.

    The PPC is not able to access the IIS Server in the PC as the Active SYnc connection is Created using a Direct connection which doesnt take IP adress for the PPC.

    Thanks

    Biju


  • Update Data in MS-ACCESS in PC from PPC