Thanks for your information Micheal!
We now connect through ODBC via a DSN.
When I read some articles they recommend using SQLOLEDB. It's said to be faster and more relaible.
Do you (or anyone) know how much faster it is? Should we really use SQLOLEDB?
Thanks in advance

>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
>