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

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

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.