MySQL Forums
Forum List  »  Connector/ODBC

Very slow when connection lost
Posted by: Andrew Burnett
Date: January 23, 2021 03:01PM

I am running the MySQL connector with ADODB in VBA in Excel. I am maintaining a persistent recordset which the user can move through with various buttons. If the connection gets temporarily dropped, then subsequent operations on the recordset cause the program to hang for about 3 minutes before returning an error. I cannot find any timeout setting anywhere near 3 minutes. How can I get the program to respond more quickly in this situation, or alternatively detect the connection has dropped?

Options: ReplyQuote


Subject
Written By
Posted
Very slow when connection lost
January 23, 2021 03:01PM


Sorry, only registered users may post in this forum.

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.