Hi Drew, Keith,
> > I use MySQL Query Browser and no matter how long I leave it, for > days > > even, I can just type a query and execute it. No reconnection > required > > besides just the original one when I started the program. > Actually Query Browser times out also - unless you are using a > localhost > database server, but I doub't that or we wouldn't be having this > discussion. (hmm, maybe I'm wrong on that - but it doesn't really > matter) > Yes, the MySQL Query Browser will also time out, but if it does, it notices this when it tries to execute a query and will ask you if you want to reconnect and then parse the query. If you click on "Yes" or "OK" (can't remember the exact message now), it will do all of this transparently. As Keith has mentioned with OOo you have to close the error message, which for some dumb reason often exceeds the size of my desktop window (because you get a load of Java error message handling drivel about nested exceptions) and is a pain to get rid of, then you have to shut down your Base file (or form) and reconnect. I regularly spend time building my queries (not an SQL guru and I like to experiment), and by the time I'm ready, discover that the damn thing has disconnected. With the MySQL Query Browser this is not an issue, as indicated above, but then again it uses a direct C++ client database access and not the Java connector driver. Perhaps this problem will go away once the native mysql driver extension is as functional as the other connectors. For the moment (I mean in its present "stable" incarnation), it isn't. I know that Frank is on holiday at the moment, so he'll probably only read all about this after he gets back and gets around to trawling through the mountain of emails that will have piled up in his mail inbox during his absence...and of course, if the problem is with the connector, and not OOo, then there will be little that can be done on the OOo side :-) Alex --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
