As a developer, I like to open up global connections and keep them open. From a DBA perspective, they like us meager developers to close the connections to help with server resources, and (I suspect the real reason) is that they don't violate their licensing.
I haven't ever had problems with the connection using VFP to SQL Server. I don't have enough experience with MySQL to say however. I would think that a connection manager, that wraps communications in a TRY CATCH would work well when attempting to keep connections open. HTH. Kevin Cully CULLY Technologies, LLC Sponsor of Fox Forward 2006! http://foxforward.net Steve Ellenoff wrote: > I'm curious what everyone's adopted standard is regarding creating > remote connections to access remote databases from VFP. _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** 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.