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
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

Reply via email to