On Feb 4, 2008 9:31 AM, MB Software Solutions < [EMAIL PROTECTED]> wrote:
> What's the best practice in this? iirc, Paul McNett does a timer > process in the background where he constantly keeps polling something > like "show tables" in order to keep the connection alive. I was doing > this for getting my handle (and thus the goal was to re-establish > connection if the simple command failed): > -------------------------------------------------------------------- Learn to live in the disconnected world? All I see is a force to attempt to ride a former connection. Why not close them and reopen? KISS. Reason is that when doing Web based stuff you won't try to force the concept of an open pipe back to your data. -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

