Tuesday, June 12, 2012 4:26 AM
I've gotten pretty good at coding Windows Forms applications using local database files. Now, I'd like to deploy the database so that it's available online (multiple Windows Forms app users can access/update the same database from multiple sites). This is an area with which I am not at all familiar...
Can I simply find a web host and stick my .sdf file on it, then have each user's instance connect to that .sdf file?
If not, any advice on how to make this happen? In fact, if anyone could suggest a free/low cost hosting company and give me a nuts-and-bolts overview of how to proceed, I'd be eternally grateful.
Thank you in advance!!
Tuesday, June 12, 2012 6:56 AMyes its possible. you just have to change your connection string and set the Data Source value
Tuesday, June 12, 2012 7:12 AM
Tuesday, June 12, 2012 7:28 AM
No you cannot, they have also to include in your subscription an SQL server which can handle the DataBase.
I don't know a free one, beside that is taking a subscription mostly locally done (where local can be very wide).
This forums is used by persons all over the world so not the best place to ask this. It is also a fact that what is seen in the USA as very low cost can be in Bengal be very high cost.
However, take a look at Azure
Tuesday, June 12, 2012 12:21 PM
SQL Server Compact Edition (.sdf) does not support remote connections via an IP address. You would need to use SQL Server Express or higher versions in order to support remote connections over IP.
In addition, you would need to contact the hosting company (which would provide the SQL Server setup) in order determine whether they would support this scenario.
Paul ~~~~ Microsoft MVP (Visual Basic)