> Do you use a different ADO connection for every query (my app does)? There is one connection per table, but it's opened to the server once and left open, unless there are SQL errors when it's reopened. This is not a web application.
In my experience, ADO connections can remain open for several months without any issues, provided the servers are not rebooted (ie Windows Update is thoroughly disabled, which is quite hard). Angus -- To unsubscribe or change your settings for TWSocket mailing list please goto http://www.elists.org/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be