QueryTimeout Property (Professional Edition Only)

See AlsovbproQueryTimeoutSee

Applies To

Database objectP8AHA.

Description

Determines the number of seconds Visual Basic waits before a timeout error occurs when executing a query on an ODBC database.  The default is 60 seconds.  Not available at design time; read/write at run time.

Syntax

database.QueryTimeout [ = seconds ]

Remarks

The database is an object variableZ3R9Q5 identifying an open Database object.

When using an ODBC database, such as SQL Server or Oracle, there may be delays due to network traffic or heavy use of the ODBC server.  Rather than waiting indefinitely, you can specify how long to wait before the database produces an error.

When set to zero, no timeout occurs.

 

Note   Does not apply to the CreateDynaset method.

 

Data Type

IntegerDOKXHY