PROPERTY:  Command::CommandTimeout

commandobject.CommandTimeout = long
long = commandobject.CommandTimeout

 
The CommandTimeout property defines how many seconds to wait before cancelling an Execute method call and generating an error. The default is thirty seconds. If you set CommandTimeout equal to zero seconds, the program will wait indefinitely or until the Execute is completed.
 
The Connection object has a similar property, but the two properties do not inherit from each other.
 
Code (VBScript):
Set objCommand = Server.CreateObject("ADODB.Command")
Set objCommand.ActiveConnection = strConnection
objCommand.CommandTimeout = 120

Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information