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!