I am opening a new connection for each query. When happens is that when the connection is closed it never returns. The ADO Close code seems to wait in a message loop on the async thread ending -- it never does so I get a block in the stack and routines run on top of it. If the async thread is terminated the stack unwinds.
On Mon, 28 Aug 2006 17:47 +0100 (BST), you wrote: > > 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 -- Rob Chafer Silverfrost -- 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
