Hi Stephen. Thanks for the reply. I do in fact close the connection each time. But for some reason, when I attempt to reconnect, if it has been too long a time since the last connection, I get that error. Also, I am developing on a laptop, and when I take the laptop to another location, from work to home for example it seems to happen there too.
There may be something else going on here, I am not sure. This doesn’t happen with sqLite databases (of course) only with mySQL databases, and the error does not say that I cannot connect, it says that a disconnect occurred while querying the database. Another factor is that I am using sqlYoga. I am not sure if Trevor is doing something behind the scenes that stores information specific to the network connection, so that is an unknown, although I don’t see why he would. This problem would also occur when I developed at my last place of employment, and the SQL server was local there, not remote as in on-rev. I have a small snippet of code that pings the sql server just to make sure I actually have a logical network connection in the first place, and that returns true even before the dreaded timeout. Might this be an on-rev problem? At any rate, I can think of multiple scenarios where a user might get disconnected from a network, and if I could reduce that timeout from one minute to something like 5 seconds or even 10 seconds, and then make sure my queried data is not too large, I could at least mitigate the problem by informing the user and allowing the user to decide if he wants to continue trying. Bob On Jan 31, 2014, at 13:36 , stephen barncard <stephenrevoluti...@barncard.com> wrote: > On Fri, Jan 31, 2014 at 8:28 AM, Bob Sneidar > <bobsnei...@iotecdigital.com>wrote: > >> I need a way to test whether or not the current connection to the database >> is still valid without invoking the 1 minute wait. Any suggestions? >> > > why do you have to keep 'connected' at all? Why not open and close the > connection with each transaction - there is practically no overhead for > that - what usually takes time is the transmission of data….. or am I > missing something? > > *--* > *Stephen Barncard - San Francisco Ca. USA - Deeds Not Words* > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
