I'm stuck with this. I had SQLite working with OpenOffice in the past. But since then i reinstalled my machine and so... Now I can't get it to work.
i pretty much followed this guide: http://documentation.openoffice.org/HOW_TO/data_source/SQLite.pdf
Except that I changed (with sudo ODBCConfig) the SQLite drivers config to:
Driver: /usr/lib/odbc/libsqlite3odbc.so Driver64: /usr/lib64/odbc/libsqlite3odbc.so Setup: /usr/lib/odbc/libsqlite3odbc.so Setup64: /usr/lib64/odbc/libsqlite3odbc.so
(Those files exist on my system)
I also added my database under the User DSN tab.
When I start LibreOffice Base and browse for a ODBC DataSource it turns up empty. I guess this isn't easy to answer without having access to my system. But maybe anyone has an idea? Or some way to debug the connection that I'm not aware of?
Here are some info about my packages:
$ dpkg --get-selections | grep odbc libodbcinstq1c2 install libsqliteodbc install odbcinst install odbcinst1debian2 install unixodbc install unixodbc-bin install $ dpkg --get-selections | grep sqlite libaprutil1-dbd-sqlite3 install libmono-sqlite1.0-cil install libmono-sqlite2.0-cil install libqt4-sql-sqlite install libsqlite0 install libsqlite3-0 install libsqliteodbc install sqlite3 install sqlitebrowser install sqliteman install sqliteman-doc install