Page 1 of 1

Trial SDAC for Delphi 7 and SQL 2005

Posted: Tue 10 Jul 2007 22:05
by kboatwri
I am using the SDAC trial components for Delphi 7 and SQL Server 2005. I have a service application, that connects to multiple databases on a regular interval. The connections are created and destroyed at each interval. This process runs fine for 10 to 15 minutes and then locks up (application stops responding, and processor time for that process pegs) without any exception thrown. It does not seem to be locking up in the same place each time. Is this symptomatic of the trial version or possibly some other issue?

Thanks!

Posted: Wed 11 Jul 2007 07:16
by Antaeus
Please describe what operations does your service application perform, what components' settings did you change (FetchAll, NonBlocking, Pooling, etc.), how many applications are run simultaneously. Can this problem be reproduced in a standard VCL-forms application?

Posted: Wed 11 Jul 2007 16:20
by kboatwri
Nevermind, I found it and it was my own thread managment issues...

Thanks!

Posted: Thu 12 Jul 2007 07:04
by Antaeus
It is good to see that this problem has been solved