Is it the TimeOut that is too short or your query that takes too long?

I would rather check the queries/indexes/... before attempting to change the time out.

Be aware that you need to change the CommandTimeout property (and not the ConnectionTimeout).


>Emergency! I need help!!! During testing with small data my program worked out just fine. Now with large data I keep getting a Time-Out Expired message from my connection object.
>
>Actually I am using ADO 2.5. Does anyone know how to increase the timeout time? I've tried to set the timeout property of the connection object to the maximum value but no luck!
>
>Please help me!