Have you compared the ado dll version numbers on each computer. Perhaps a dll upgrade is the issue
On Wednesday, February 23, 2011, <edwa...@slingshot.co.nz> wrote: > Thanks for the suggestion. > > I'm using TADOQuery, and have nothing to do with TClientDataSet, so what John > suggested doesn't apply to me at all. > > I do expect that it's Windows Update related, but I can't pinpoint which one. > I have confirmed that the same application works on my another Win2003 server, > when connected to the same database. So it's definately something to do with > the server. What I need to know is "what" caused it. Unfortunately, I can't > change/swap the server. > > I don't think rollback transaction before start is a valid option, as > ADOConnection would simply fail it. > > Edward > > Quoting Rohit Gupta <ro...@cfl.co.nz>: > >> 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 t -- Kyley Harris Harris Software +64-21-671-821 _______________________________________________ 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
