Why unexpect connection error
Posted by: chia chee bu
Date: September 15, 2006 04:01AM

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

Options: ReplyQuote


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.