database connectivity question

[JamesWPierce]

Hi,

This is a Mobile question but not really for the compact framework but
could be in the future.

The situation is this.

I have an application that will be running on a PC in a public WiFi
hot spot area. People at the WiFi hot spot will access a website that
is hosted on a different PC. I will need a database that both the
website and the application can access. I dont have control over the
public WiFi network only wireless internet access.

Should the database be on the webserver or on the application PC or on
both and synchronized. What is the best database connection method to
use with SQL Express and this scenario?

Thanks

 

[Guest]

This is dependent on the requirements as always.

There is no "best way". It depends on your client. For example if you don't
have control of the Wi-Fi network the two PC's require in order to
communicate, what should the application do if connectivity goes down? Is it
possible to continue using the app if it does go down, is it imperitive that
the app continues working while no access to the server can be made? Does the
application need its own local data store?

What is this database for, where does the business logic code run? .....

Developing an "occationaly connected" application is expensive.

It is always difficult to advise how to architect a solution if we don't
know the fundemental requirements.

See if this document is of any use:
http://msdn.microsoft.com/mobility/...ary/en-us/dnppcgen/html/sometimesoffline2.asp

It covers CF development not desktop but the principle is the same.