Sample Header Ad - 728x90

Problems with unixODBC and SQLite

4 votes
1 answer
4094 views
I installed unixodbc, sqlite3 and libsqliteodbc. odbcinst.ini looks like this: [SQLite] Description=SQLite ODBC Driver Driver=libsqliteodbc.so Setup=libsqliteodbc.so UsageCount=2 [SQLite3] Description=SQLite3 ODBC Driver Driver=libsqlite3odbc.so Setup=libsqlite3odbc.so UsageCount=1 odbc.ini looks like this: [mysqlitedb] Description=My SQLite database Driver=SQLite3 Database=/my_database.db 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; 1|admin|password
Asked by Dánjal Salberg Adlersson (429 rep)
Jan 31, 2014, 04:21 PM
Last activity: Sep 1, 2021, 04:18 PM