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!