ADO 30 Sec Time Out

[ThunderForest]

Also see thread 102-568437 in this forum.

I am experiencing this problem using Delphi 5 and 7, executing stored procedures on SQL Server from a ADODataSet or ADOQuery. Typically happens with large result sets. Procs run as expected using Query Analyzer, but I continually time-out after about 30 seconds using ADO. CommandTimeout is zero (0). I am told the SQL Server database timeout settings are okay. Is it true that only the ADO command component will only accept the command timeout setting, as said in the above thread? If so, how do you get a result set from it?

Getting answers before I'm asked.
Providing answers if I can.

 

[ThunderForest]

I did see this link, which I think confirms what I mentioned:

http://support.microsoft.com/kb/190606/en-us

Also, to get a dataset, I did this:

ADODataSet1.RecordSet := ADOCommand1.Execute;

I am now able to control the time-out issue (no longer timing out at 30 seconds), but it now times out at whatever I set the ADOCommand command timeout setting to. My connection is good, the stored procedure name is in the ADOCommand command text, the program successfully creates stored procedure parameters for the ADOCommand parameters. I do not get a result set. Anything I'm missing?

Getting answers before I'm asked.
Providing answers if I can.