In general, if your data access technology supports using the OLEDB Provider for SQL Server, you should use it.
The only exceptions would be with a .NET application, where you should use the SqlClient provider.
-Mike
>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
>>