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
_______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: delphi@delphi.org.nz Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: unsubscribe