I am getting an ADO timeout (SQL 7/ TAdoQuery) on a select statement that takes 53 seconds to return data. The documentation talks about CommandTimeout - which I have tried to set to -1 (gens error) and 36000 - but still the timeout occurs.
What I am doing wrong and what can I do about this?
What I am doing wrong and what can I do about this?