Accessing remote db

[John]

Hi

We have windows 2003 mobile phone devices which can establish internet
connection via gprs. We also have a database of company contacts on a
windows 2003 server (sbs2003 to be precise). The database is currently ms
access but can be upgraded to sql server if required. We need to be able to
view & edit the contacts db on the mobile devices. What would be the
strategy to do that i.e. how does the contacts db gets accessed and modified
on the mobile devices via gprs/internet? Any pointers would be greatly
appreciated.

Thanks

Regards

 

[João Paulo Figueira [eMVP]]

I believe that a good place to start would be by writing a web service to
allow remote applications to access the database. My experience is that you
will find it very easy to both publish the web service and to consume it.

 

[John]

I would like to do it in a way that if internet connection to server is not
available, it still works. For example when abroad where gprs does not work
or in a tunnel etc. Possibly in a way that when the connection is restored,
any outstanding updates are synchronised both ways. What is the procedure
for this?

Thanks

Regards

 

[Ilya Tumanov [MS]]

You have to create a local data storage which would be synchronized with
remote data base from time to time.
SQL CE with RDA/replication might be a good choice. It uses IIS, so it
should work over GPRS as well.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------