I am trying to automate the update of a sql database table
from a flat dilimited  file. I first want to delete the
existing records in the table, but receive the error # 5
timeout expired. The table contains about 50000 records
and if I delete it from within SQL it takes about 90
seconds to delete. How do I disable the timeout to allow
the delete to complete, or create a wait while it
completes. Before continuing on with the remaining code.

Thanks

Please see my response to this post in the ADONet newsgroup.

Steven Bras, MCSD
Microsoft Developer Support/Visual Basic WebData

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
http://www.microsoft.com/security.