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

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
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