Basically I am creating a database driven website in Web Developer 2008. The database is stored in the App_Data folder of my website project. Could I have an iPhone, Blackberry, Symbian, Windows Phone, webOS or Android app access the database via an HTTP (or some other type of) request?
I would like to know if this is possible before I move too far in the programming.
It is very possible, although perhaps the most secure method would be to abstract the connection to the database through a WCF service or even a conventional web service.
That way the database connection string remains on the server, and the web service will allow pass-through connectivity, so to speak. This is just a security layer to prevent someone from grabbing the database connection string and accessing your database directly.