Latest

recent

ADO CommandTimeout Property


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
%>
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
%>

Goto ADO Connection Object Complete Reference
ADO CommandTimeout Property Reviewed by 1000sourcecodes on 08:48 Rating: 5
Powered by Blogger.