## Setting up ODBC for SQLite on Ubuntu

First install the SQLiteODBC and unixODBC packages. Have a quick look at the documentation for unixODBC and SQLiteODBC.

After the install you’ll have a a /etc/odbcinst.ini file which will look something like this:

Next you need to set up a DSN entry for your SQLite database. You’ll edit your ~/.odbc.ini file to resemble this:

Obviously the name, description and path for your database file will differ.

Right, we’re ready to use isql to open the database and execute queries.