Very slow when connection lost
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?
Subject
Written By
Posted
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.