Posted by Andrew B. Collier on 2015-09-17.
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.