Opens or creates a SQLite database.

Syntax:

object.Close

Examples:

Set db = Server.CreateObject("newObjects.sqlite.dbutf8")
If db.Open(Server.MapPath("/db/mydb.db")) Then
  ' Continue with the actual work
  ' ...
  ' Finish everything
  db.Close
Else
  ' Deal with the error further
  Response.Write "Error occured: " & db.LastError
  ' ... 
End If

Remarks:

In the most COM programming environments the object variables are released automatically when the program exits the scope where the variable is defined. The SQLite COM object interrupts all the running tasks and closes the DB when released. Therefore you can omit the Close call in most cases in which it is clear when the object will be disposed.

The method never fails.

Applies to: SQLite COM object

See also: Open, BusyTimeout,LastError

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