Thread View: borland.public.cppbuilder.database.ado
3 messages
3 total messages
Started by Student
Wed, 28 Mar 2001 22:00
ADOQuery
Author: Student
Date: Wed, 28 Mar 2001 22:00
Date: Wed, 28 Mar 2001 22:00
1 lines
824 bytes
824 bytes
Does anyone know why ADOQuery component times out?
Re: ADOQuery
Author: Michael Crapo
Date: Thu, 29 Mar 2001 16:37
Date: Thu, 29 Mar 2001 16:37
11 lines
1114 bytes
1114 bytes
More than likely it is because your query is taking longer than the CommandTimeout in the ADOConnection. It is defaulted to 30 seconds. Try increasing it. On Wed, 28 Mar 2001 16:00:27 -0600, "Student" <kevin.wise@mtifwb.com> wrote: >Does anyone know why ADOQuery component times out? > > >
Re: ADOQuery
Author: Mark Cashman
Date: Sat, 31 Mar 2001 01:05
Date: Sat, 31 Mar 2001 01:05
16 lines
1437 bytes
1437 bytes
Hi, Kevin! Watch out to make sure your transactions are closed. I had a problem with trying overlapping or nested transactions causing timeouts. Also keep in mind that separate connections can lock each other out with transactions. As far as the DBMS is concerned, they are separate users. ------ Mark Cashman (TeamB - C++ Builder), creator of The Temporal Doorway at http://www.temporaldoorway.com - Original digital art, writing, music and more - C++ Builder / JBuilder Tips and The C++ Builder Programmer's Webring (Join us!) http://www.temporaldoorway.com/programming/index.htm ------
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads