Latest web development tutorials
 

ADO CommandTimeout Property


< Complete Command Object Reference

The CommandTimeout property sets or returns the number of seconds to wait while attempting to execute a command, before canceling the attempt and generate an error. Default is 30.

Syntax

object.CommandTimeout

Example - For a Command object:

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"

set comm=Server.CreateObject("ADODB.Command")
comm.CommandTimeout=10
response.write(comm.CommandTimeout)

conn.close
%>

Example - For a Connection object:

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"

conn.CommandTimeout=10
response.write(conn.CommandTimeout)

conn.close
%>

< Complete Command Object Reference