Why unexpect connection error
Dim myConnSt = "Database=emaillist;Data Source=localhost;User Id=root;Password=root; compress = true"
Dim da As New MySqlDataAdapter
Dim ds As New DataSet
Try
Dim dbconn As New MySqlConnection(myConnSt)
qryStr = "SELECT a.email, a.stat FROM allmail AS a WHERE a.stat <> '1'"
da.SelectCommand = New MySqlCommand(qryStr, dbconn)
da.Fill(ds, "ALLMAIL")
Dim dt As New DataTable
dt = ds.Tables("ALLMAIL")
MsgBox(dt.Rows.Count, MsgBoxStyle.Information)
Catch ex As MySqlException
MsgBox(ex.Message)
MsgBox(ex.Number)
End Try
Remarks:
data table of allmail contained 4,xxx,xxx record.
When run this process, wait around 15mins and return error message:
"Unexpect connection error..."
anybody can tell me why?
Thanks
Subject
Written By
Posted
Why unexpect connection error
September 15, 2006 04:01AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.