Re: Timeout parameter for MySqlConnection?
Posted by: Gene Holmerud
Date: June 27, 2017 12:32PM

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?


Options: ReplyQuote

Written By
Re: Timeout parameter for MySqlConnection?
June 27, 2017 12:32PM

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.