Get started for free
Visual Studio Developer Center >
> 
> 
Windows Forms application using an online database

Answered Windows Forms application using an online database

  • Tuesday, June 12, 2012 4:26 AM
     
     
    Sign In to Vote
    0

    Hi, everyone!

    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!!

    Jack

     

All Replies

  • Tuesday, June 12, 2012 6:56 AM
     
     
    Sign In to Vote
    0
    yes its possible. you just have to change your connection string and set the Data Source value 
     
  • Tuesday, June 12, 2012 7:12 AM
     
     Answered
    Sign In to Vote
    0

    I doubt you will find any webiste, that will host (any) sql database, expecially not for free. If you can create some database, you will never get a connection string from there; which we know is a vital part to access to database. So the anser to your question is no.

    To avoid this, I`d suggest:

    To buy some cheap pc (or laptop) by your self (or even use your own). Put some wins and sql server on it - and this is it -you will have your own server. There is ms sql Server 2008 or latest 2012 Express editions, which are for free, and they both provide a remote access (over net).

    What do you say?

    Mitja

     
  • Tuesday, June 12, 2012 7:28 AM
     
     Answered
    Sign In to Vote
    0

    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

    https://www.windowsazure.com/en-us/develop/overview/

    Success
    Cor



     
  • Tuesday, June 12, 2012 12:21 PM
     
     Answered
    Sign In to Vote
    0

    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)