Page 1 of 1
[Solved] Connect to SQLite database
Posted: Mon Nov 01, 2010 7:26 am
by 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?
Re: Connect to SQLite database
Posted: Mon Nov 01, 2010 11:22 am
by r4zoli
You can connect with ODBC driver:
http://www.ch-werner.de/sqliteodbc/ .
JDBC connection not working, due to some issue.
Re: Connect to SQLite database
Posted: Mon Nov 01, 2010 12:32 pm
by 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.
Re: Connect to SQLite database
Posted: Fri Nov 05, 2010 4:38 pm
by Devlei
Thanks for your responses r4zoli and rudolfo, I'm starting to get the hang of things.