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.
