Lost connection to MySQL server during query

[vbturbo]

Hi

I have tried to set the connectiontimeout to 20 sec. but doesn't seem to work.

im using a straight forward select command

Private _con As MySqlConnection

Public Function getDataTable(ByRef strSQL As String) As DataTable
Dim strcon As String = ""
strcon = ConfigurationManager.AppSettings("ConnectionString")
_con = New MySqlConnection(strcon)


Dim da As New MySqlDataAdapter(strSQL, _con)

Dim objDataTable As New DataTable()

_con.Open()

Try
da.Fill(objDataTable)
Catch
_con.ConnectionTimeout = 20
da.Fill(objDataTable)
End Try
_con.Close()
_con.Dispose()

Return objDataTable
End Function


in my database table there are 15- 20 rows and 6 columns!

what can i do?

[Alexey]

Try to increase da.SelectCommand.CommandTimeout property.

[vbturbo]

what is the default (time in sec.)for this property ?

Jens

[Alexey]

The default value is 30 seconds.