Checkout the OleDbCommand.CommandTimeout
Gets or sets the wait time before terminating an attempt to execute a
command and generating an error.
The time (in seconds) to wait for the command to execute. The default is 30
A value of 0 indicates no limit, and should be avoided in a CommandTimeout
because an attempt to execute a command will wait indefinitely.
Hope this answers your question
Ramesh Thyagarajan, MCSD,MCDBA
Microsoft Developer support
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit