I installed unixodbc, sqlite3 and libsqliteodbc.

odbcinst.ini looks like this:

Description=SQLite ODBC Driver

Description=SQLite3 ODBC Driver

odbc.ini looks like this:

Description=My SQLite database

When I test connection like this:

isql -v mysqlitedb

it says Connected!

But when I try a SELECT statement it says:

SQL> select * from user
[S1000][SQLite]no such table: user (1)
[ISQL]ERROR: Could not SQLPrepare

What is wrong?

I known the table: user is present, because I get results when I do this:

sqlite3 /my_database.db
SQLite version 3.8.2 2013-12-06 14:53:30
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select * from user;
  • I can not reproduce this on OS X with unixodbc-2.3.4, sqliteodbc-0.9994, and a database in my $HOME, nor with the database in /. (i.e it works as expected) – Kusalananda Jul 30 '16 at 6:29

You sure about this path in your odbc.ini file?


I would make sure that you don't need to specify the actual path to the sqlite DB file there.

| improve this answer | |
  • Now I am not sure how isql works. I set the path to a database that does not exists. It says Connected! There are no tables in the database, so I create some and then I quit isql. I search the disk to see if the a database is create, but I do not find any. – Dánjal Salberg Adlersson Feb 3 '14 at 10:40
  • @DánjalSalbergAdlersson - Examples I'm finding on the net show it as a full path. So that would be putting that file at the / directory. Can you confirm if it's there or not? Also you can locate files often times using this command locate my_database.db. – slm Feb 4 '14 at 7:27
  • @DánjalSalbergAdlersson - another example: lojze.lugos.si/~darja/software/r/library/RODBC/README – slm Feb 4 '14 at 7:40
  • I tried changing location of DB and changing full path, but it still does not work. I check for leading spaces in config, but that did not help. I am wondering if there is something wrong with the drivers? I checked the dependencies of the drivers and they seem OK. – Dánjal Salberg Adlersson Feb 5 '14 at 10:56
  • @DánjalSalbergAdlersson - I tried to set this up on my Fedora 19 system and I haven't gotten it working yet either. Was there a guide you were following for the setup? This combination seems unused, I found very little info on unixODBC + sqlite. – slm Feb 5 '14 at 13:29

Not the answer you're looking for? Browse other questions tagged or ask your own question.