Help

[cisco]

What is wrong with this code i get a error everytime
rivate Sub log_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles log.Click
Dim strCommandText As String = "SELECT COUNT(*) as USRMATCH FROM USER WHERE " & _
"USERNAME = '" & Me.user.Text & "' AND PASSWORD = '" & Me.pass.Text & "'"

Dim sqlconn As New SqlConnection _
("data source = localhost; initial catalog=ICS; user ID=sa;password=xxx")
sqlconn.Open()



Dim iResult As Integer
' iResult = Convert.ToInt32(SqlConn)
If iResult <> 0 Then
SqlConn.Close()

Else
MsgBox("Invalid UserID or Password Please enter your UserName and Password")
End If

[TLord]

Can you post more information about the exception please?

[cisco]

this is the error i get
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

Additional information: System error.

the code is


Private Sub log_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles log.Click
Dim strCommandText As String = "SELECT COUNT(*) as USRMATCH FROM USER WHERE " & _
"USERNAME = '" & Me.user.Text & "' AND PASSWORD = '" & Me.pass.Text & "'"

Dim sqlconn As New SqlConnection _
("data source = localhost; initial catalog=ICS; user ID=sa;password=xxx")
sqlconn.Open()



Dim iResult As Integer
' iResult = Convert.ToInt32(SqlConn)
If iResult <> 0 Then
SqlConn.Close()

Else
MsgBox("Invalid UserID or Password Please enter your UserName and Password")
End If

[mendhak]

Originally posted by cisco
data source = localhost;

Localhost? I doubt if that is correct. Has this worked in the past? Are you sure it's not (local) ?