[Solved] Connect to SQLite database

[Devlei]

My mobile application uses a SQLite database which has a synchronised copy on my desktop. How do I connect to that database with Base?

[r4zoli]

You can connect with ODBC driver: http://www.ch-werner.de/sqliteodbc/ .
JDBC connection not working, due to some issue.

[rudolfo]

For anything related with external databases http://dba.openoffice.org is a good place to start.
Interestingly their FAQs don't say anything about SQLite. This could either mean that there are no problems with the SQLite driver ... or that it is so rarely used that hardly anybody reports problems.
Still if you look at the navigation bar at dba.openoffice.org you will find a link (after PostgreSQL and the mdb tools) about SQLite (native sdbc driver). The binary files (for linux) are located on the same site as the above mentioned ODBC drivers: http://www.ch-werner.de/sqliteodbc/sqli ... -0.1.1.zip. No Windows binaries available and it is not tested on windows either. Also somewhere on the site they mention that the sdbc driver is in alpha state. The binaries for Linux in the zip archive are from 2004, so I guess this sdbc driver is not really maintained anymore.

In short use the ODBC driver as recommended by r4zoli above. I use ODBC as well and I haven't got any problems so far. But note that I don't use Base for Data Definition only to view and edit tables.

[Devlei]

Thanks for your responses r4zoli and rudolfo, I'm starting to get the hang of things.