Connection Error

[sonu5588]

I am facing problem in connection. This code is OK , when i Deploy or Create a EXE of this project and install it on other system then the connection error generates, whats the solution to create a globel connection, any body tell me ,,,,,,,......

Public Class Utils
    '//**************** Connection MUNNA-AB15B2413\SQLEXPRESS
    Public Shared Connection As String = "Server='MUNNA-AB15B2413\SQLEXPRESS';uid=sa;pwd=123;Initial Catalog=ICS"
 
End Class
 
 
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdlogin.Click
        Dim con As New SqlConnection(Utils.Connection)
        con.Open()
        Dim Query As String = "Select * from Login WHERE username = '" + txtusrname.Text + "' and password = '" + txtpwd.Text + "'"
        Dim cmd As New SqlCommand(Query, con)
        Dim reader As SqlDataReader = cmd.ExecuteReader
        If reader.Read Then
            Main.Show()
            Me.Hide()
        Else
            MsgBox("Invalid Username / Password")
        End If
 
    End Sub

[kenobewan]

Seems like you are going to need an IP or domain to use in your connection string.

[aamirvip]

you are right ken...