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
Last activity: Sep 1, 2021, 04:18 PM