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
Thanks alot!