Connecting to a SQLite database

A SQLite database is represented as a single file with the extension .db. The database file can contain any number of tables.

StepsTo connect to or to create a SQLite database

  1. Select SQLite Persistent from the Interface drop-down list.

  2. Enter a new or existing file name for the SQLite database in the Host Name property. A new name will automatically create a new SQLite database file with an extension .db. Do not enter the extension .db when entering the name of an existing SQLite database.

For example, to create a new SQLite database file mySQLite.db or to connect to an existing mySQLite.db database file:

The database file created is named mySQLite.db.