VB 2010 and database on website
I have an application that connects to a database on my computer. What I want to do is host this database on my website. How would I go about changing the Data Source from a local file on my computer to a database on my personal website (hosted by GoDaddy)? The database is basically for saving the data of a character. The vb application will be the game that a user can install. I just want the data saved to a database on the website instead of on their local machine. Is this easily doable? It is an Access database(.accdb). Thank you.
Re: VB 2010 and database on website
Re: VB 2010 and database on website
Having looked at it, I'm not sure that biilboy's link will be of use to you. While it is possible to connect directly from a desktop app to a database on the internet (definitely with SQL Server, definitely NOT with Access, maybe with MySQL) it is generally not done because it is rightly considered a security risk. As such, many web hosts simply won't allow it. What you should do is create a web service that will be hosted and connect to the database internally. Your app can then communicate with that web service. You would still not use an Access database, which should really just be used in local, single-user scenarios.
