Edward,

I have something similar at only one site. They get transaction already started error. And only they do. I have gone through the code several times - every query is try/finally and try/except bracketed and all transaction starts/commits/rollbacks are correct.

It just occurs to me that if the sql server uses tcpip (which firebird does and I am using firebird) then it could be windows dropping the tcpip transactions. I know it is stupid in many other situations where it clears the stack. I suppose this could also happen due to window updates.

As John says, closing the query prior to use may be the answer. I dont like the idea myself, but I may have to do rollback before start :-(




On 21/02/2011 8:54 p.m., Edward Huang wrote:
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


__________ Information from ESET NOD32 Antivirus, version of virus signature database 5891 (20110220) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


_______________________________________________
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


__________ Information from ESET NOD32 Antivirus, version of virus signature 
database 5891 (20110220) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com



--
Regards

*Rohit Gupta*
B.E. Elec., M.E., Mem IEEE, Mem IET
Technical Director
Computer Fanatics Ltd

*Tel *4892280
*Fax *4892290
*Web *www.cfl.co.nz
------------------------------------------------------------------------
This email and any attachments contain information, which is confidential and may be subject to legal privilege and copyright. If you are not the intended recipient, you must not use, distribute or copy this email or attachments. If you have received this in error, please notify us immediately by return email and then delete this email and any attachments.
_______________________________________________
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

Reply via email to