We get a Timeout Expired error when we select a fairly large recordset from
a SQL Server table. Has anyone got any help for me ons this please! We dont
get that error with a BDE Query component with exactly the same SQL
statement.

Have a look at yesterday's thread 'How can I change the timeout in
TADOQuery'

Reinhard

The best solution is to switch to a TadoDataSet where the commandTimeOut
property works.   You can also set it in code by casting as a TadoDataset

(AdoQuery1 as TadoDataSet).CommandTimeout := 100;
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com