Re: Timeout parameter for MySqlConnection?

[Gene Holmerud]

Thank you so much Jose for the tip. I kept googling for the parameters, but kept getting snowed.

The connect happened in about 30 seconds, but then I got:

Exception thrown: 'System.InvalidOperationException' in MySql.Data.dll
The process failed: System.InvalidOperationException: Connection must be valid and open.


On statements:

sqlcmd = New MySqlCommand("SELECT RoomA complaint WHERE GlobalRound='RR1'")
dr = sqlcmd.ExecuteScalar()

with and without the "complaint" parameter. Those appear just after some Dim stmts that follow the connect.Open() [which now has the ConnectionTimeout parameter].

Any clue?

Gene