title: ADO components CommandTimeout
body: <p>I have a problem with settings of the query execution timeout with TADOQuery, TADOCommand or TADODataSet (I've tried it with each one). I have a tiny application, which connects to the database and <strong>periodically executes stored procedures, which returns dataset as a result</strong>.
  My aim is to keep this application always online, but my problem is that when the connection is lost, the timeout of just executed command (through the one of the mentioned components) takes the default 30 seconds. I've been looking for the solution, but nothing works.
  <strong>Could you give me an advice, how to set the CommandTimeout e.g. to 5 seconds or better to say how to modify ADODB.pas for respecting my own timeout, please ?</strong></p>
  
  <p>There were many "solutions" for this, like set DataComponent.Connection.CommandTimeout := 1; but really, nothing works. I'm using D2009, MSSQL2005 and the connection along with the data component is created dynamically in the thread.</p>
  
  <p><strong>The last, what I've tried is this</strong></p>
  
  <pre><code>// protected variable owned and created in the thread with its own connection
  var Query_Object: TADODataSet; 
  
  // connection timeout is set to 3 seconds
  Query_Object.Connection.ConnectionTimeout := 3;
  ...
  
  // this piece of code I'm calling periodically in the only one existing thread
  ...
  SQL_Query := 'EXEC my_procedure_which_returns_dataset'
  
  with Query_Object do
    begin
      Close;    
      CommandType := cmdText;
      CommandText := SQL_Query;
      CommandTimeout := 5;             // doesn't affect the timeout
      CursorLocation := clUseServer;   // let the dataset retreives prepared data
      Open;
    end;
  
  // and here I need to get faster than in the default 15 seconds to let the user
  // know that the reading takes more than mentioned 5 seconds
  ...
  </code></pre>
  
  <p>Thanks a lot :)</p>