Definitely - you don't get far without it :-) Stephen
-----Original Message----- From: David at McNeill Computers [mailto:[EMAIL PROTECTED] Sent: Wednesday, 28 May 2003 11:39 a.m. To: Multiple recipients of list delphi Subject: RE: [DUG]: ADO funny Have you applied the ADO Update 2 from Borland to your Delphi 5? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stephen Bertram Sent: Wednesday, 28 May 2003 8:53 a.m. To: Multiple recipients of list delphi Subject: [DUG]: ADO funny Hi All A strange occurrence which I am unable to explain, but I feel that I have seen before. This is with Delphi 5 and SQL Server 2000. We have a thread which updates a SQL Server database via a stored procedure when monitored data in the application is changed or added. The thread instantiates its own TADOConnection and a TADOStoredProc. As changed data is detected the TADOStoredproc's parameters are updated and the ExecProc method called. The purpose of the thread is to pipeline database updates from the 20 - 500+ execution threads handling client processes. On one machine (Windows Server 2000) the second time the ExecProc method is called the application vanishes - no errors, no Dr Watson. On all other machines we run it on the application behaves beautifully. The failure occurs with only 12 active threads, so it does not seem to be load related as the application happily runs in the real world with over 1500 threads. The fix has been to instantiate the TADOStoredProc for every database update and then free it. While this works it is not elegant and as it may run up to 100 times a second the inefficiency is a problem. Any ideas what may be the cause, either from the ADO components or the Windows 200 Server environment? TIA Stephen --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ Disclaimer : This communication contains information that is confidential and the copyright of enSynergy Limited or a third party. If you are not the intended recipient of this communication please delete and destroy all copies and telephone enSynergy Limited on +64 9 9205441 immediately. If you are the intended recipient of this communication you should not copy, disclose or distribute this communication without the authority of enSynergy Limited. Any views expressed in this Communication are those of the individual sender, except where the sender specifically states them to be the views of enSynergy Limited. Except as required by law, enSynergy Limited does not represent, warrant and/or guarantee that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
