SQLite Configuration

Modified by Phil Loughhead on Jun 15, 2017

Step 1

SQLite is a relational database system and is commonly deployed as a library based database. The configuration settings required to connect to an SQLite data source are simple a data source name and location. The ODBC connector can be specified as SQLite2 or SQLite3

Step 2

To update the data source based on the profile configuration settings, click on the ODBC synchronise toolbar button. If the data source is in use or locked by any other application then it will not be synchronised.

Step 3

The ODBC data source will be added to the user DSN and be visible in the ODBC data source administrator tool (included as part of the Windows OS).

Step 4

Tools such as SQLite Expert can be used to connect to and inspect the data source.

 

You are reporting an issue with the following selected text and/or image within the active document: