[DUG] Object was open

[Edward Huang]

Hi,
 
I'm having a strange error recently.  We have a program that has been
running on a Win2003 server for a long time, and suddenly from last week it
comes up 'Object was open' errors.
 
Typically, the program uses 2 TADOQuery, one will select/Edit/Post, another
one with an 'Insert into xxx' query, both pointing to a same SQL Server 2005
table.  The pattern appears on many places.
 
Disregard the nicety of the logic, it has been done that way for over 5
years, first on Win 2000 server with SQL Server 2000, and later on Win 2003
server with SQL Server 2005, and was all fine, until about a week ago.
 
I have tried Google, but couldn't really find any useful link to my
situation, although there are lots of link to the same error.  I'm
suspecting some kind of OS patch or such which changed behaviour of ADO or
MDAC or SQL Server.
 
Anyone has a suggestion to my situation?  I'm not keen on changing all the
code to use different logic, as it would require fair amount of coding and
testing.
 
Thanks,
 
Edward
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20110221/9b974ee9/attachment.html