problem with Timeout Expired"

From: Gary Lafferty (gary.lafferty_at_turner.co.uk)
Date: 12/21/04 

Date: 21 Dec 2004 08:07:44 -0800

Hi all,

I am having a problem with my project, where it is giving a 'timeout expired' error message.

I did some research on the Net already, and found that most people are having this problem when trying to generate a TADOquery. However, I have a slightly different issue.

I have a TADOquery active, using TADOconnection1, and I can see the (11) records okay.

I then begin a new transaction on TADOconnection2, and start to iterate through the TADOquery as follows:

ADOconnection2.begintrans;

QUERY1.first;
while NOT QUERY1.eof do
 begin
  ADOcommand1.execute();
  ADOcommand2.execute();
  ADOcommand3.execute();

  QUERY1.next;

 end;

ADOconnection2.committrans;

The project halts on the QUERY1.NEXT line on the 8th record in the TADOquery. It gives the error "timeout expired".

I cannot understand why this error is coming up, as QUERY1 is already active ?? (and I can see the 11 records on the screen in a grid).

The ADOcommands are using ADOconnection2, and are inserting new records.

Any advice would be much appreciated, as I am now at a complete halt with my project.

Thanks in advance!