ConnectionTimeout is not that same thing as QueryTimeout. ConnectionTimeout is the amount of time that MDAC will wait when trying to connect to the server.

As for the query running so long, you might try running it through the Index Tuning Wizard.

-Mike

>Dear Experts,
>
>We sometimes get an SQL Server timeout when running large queries (not always!).
>When I run the query in the QA everything seems OK.
>Whe connect throught a ADODB.Connection object via a DSN with de command and connection timeouts set to 600.
>The query execution time in the QA is about 90 seconds, which is much less then 600, so that should be OK.
>Has anyone ideas?
>Thanks in advance.
>
>Regards,
>Leo