Hai All,
I have made a desktop application in Visual studio 2010( vb.net) with sql server 2008 as backend.I have made the setup of the project ,with sql database to be created using installer class and its all working well and fine. but i want to make my application in such a way that it has to be installed in client's computer , and make the application and database be accessible to all computers in that network.How can I do that and do i have to make my setup again to make the changes?
any helpful suggestions requested.
Thanks In Advance

5 Years
Discussion Span
Last Post by Begginnerdev

It sounds like you need a server/client setup, or you could add a way for the user to configure the path to the database ( on the local network ) using a DNS name or IP. (Static IP will be necessary if you wish to do it only once)

For example:

1)Place a button for configuring the connection
2)Place a text box for the string
3)Save the new value to the project settings:

Private Sub btnConfigure_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnConfigure.Click
    'sServerString will be defined in the project Settings
    My.Settings.sServerString = txtConnectionString.Text

    'Now when creating your connection string, do something like this:

    'Dim con As New OleDBConnection("Provider=SQLXMLOLEDB.4.0;Data Provider=SQLNCLI11;Data Source=" & My.Settings.sServerString & _
    ";Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;")
End Sub

Edited by Begginnerdev

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.