I'm losing connection to a mySql database on the WAN after a period of inactivity (only a few minutes).
I get a "Lost connection" error when I do a rst.update (funny thing, if I do it 2 more times, it seems to re-connect by itself and rst.update works, which is good because all the recordset info is intact when it re-connects by itself).
The question is: is there a way or command to make it re-connect without having to to rst.update 2 more times?
Better yet, how can I make it so that it won't loose connection after any period of inactivity?
(btw, in previous solutions cn.connectiontimeout was recommended. this is not correct).