就在上周五,这段代码运行良好,我能够在 MySQL 数据库中创建一个表,但现在它显示错误"IO 操作超时",需要解决方案的人谢谢。
Private Sub toCreateTable()
Dim varString As String = "tablenaming"
Dim Query As String
Dim con As MySqlConnection = New MySqlConnection("server=192.168.0.1; user=logging; database=db_logging; port=3306; password=passing;")
con.Open()
Query = "CREATE TABLE `" & varString & "` ( usernames varchar(50) ) "
Dim cmd As New MySqlCommand(Query, con)
If (cmd.ExecuteNonQuery()) Then
End If
con.Close()
End Sub
尝试捕获....把它放在你的"如果然后结束如果"的位置。
Try
cmd.ExecuteNonQuery()
'any other code that needs to be completed after running query
Catch ex As Exception
MsgBox(ex.Message)
Finally
con.Close()
End Try
然后,如果您收到任何异常消息,请告诉我们