Sets the busy timeout in milliseconds.

Syntax:

object.BusyTimeout = value

Remarks:

The BusyTimeout if set instructs the engine to wait and retry if it cannot open a database or perform a query because of a lock obtained over the file or portion of it by another instance. This allows you to avoid errors when multiple instances of the SQLite COM objects are running over the same database. If it is desired you can ignore this feature and take care about this externally from your application - e.g. handle the errors and repeat the attempt after some time. However this will require additional efforts that can be avoided by using the internal engine capability to re-attempt the operations.

Applies to: SQLite COM object

Supported on:

Windows 95/NT and later
Windows CE 3.0 and later
Pocket PC/Windows Mobile 2003 and later
Windows CE.NET 4 and later