Connecting to SQLite

Before you can use an SQLite database with AQT, you need to download and install the SQLite ODBC Driver.

This can be downloaded from http://www.ch-werner.de/sqliteodbc/. Go to the Current Version section and select sqliteodbc.exe. Once you have downloaded this file, run it to install the ODBC Driver.

There are a number of third-party ODBC Drivers, such as Devart (https://www.devart.com/odbc/sqlite/). We haven't used this ODBC Driver so cannot comment on its capabilities.

Once you have done this, you can connect to an SQLite database in one of two ways.

Setting up a Datasource for the SQLite Database

You would use this method if you had an SQLite database you wish to use on a frequent basis.

• from the AQT Signon window, click on New
• select SQLite3 ODBC Driver (probably near the bottom) and click on Next
• on the dialog that is displayed, click on Browse to select the SQLite file you wish to access. Enter a Data Source Name for this Datasource then click on OK.
• you should now see this Datasource in the list of Databases. Select this then click on Sign On.

Doing a one-off connection to an SQLite Database

If you do not wish to create a Datasource for your SQLite database, you can connect to it by:

• on the AQT Signon window, select Direct Connect (at the top of the window)
• in the list of Drivers, select SQLite3 ODBC Driver (probably near the bottom)
• click on the button to the right of the File Name box to select the SQLite database
• click on Sign On.