Hi all, Finally I found the problem. I asked infrastructure support team to compare the 2 servers, and it turns out that the server having problem is short of memory, due to a rogue service from virus checker taking up 1GB memory after running for a few months. After rebooted the server, it all runs fine now. I just didn't check the obvious memory problem at the first instance. Thanks anyone who show interest and offered help. Regards, Edward
_____ From: delphi-boun...@delphi.org.nz [mailto:delphi-boun...@delphi.org.nz] On Behalf Of Kyley Harris Sent: Wednesday, 23 February 2011 5:31 p.m. To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] Object was open 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 >>> >>>
_______________________________________________ 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