Have not been able to find a JDBC driver which works for me so all is based upon ODBC for the connection.
![how to open sqlite database how to open sqlite database](https://i.ytimg.com/vi/Wwne0zILe6g/maxresdefault.jpg)
How to open sqlite database how to#
Haven’t used in quite a while so again tested how to set up again today. Regardless, here is a set up I use on Xubuntu 16.04 (last test was with LO 5.4.x but others used). Additionally, most other report generators I have used are Java based. I can get SqLite to work on Base with tables & forms but not Report Builder unless Java JRE (or even OpenJDK) is installed. If one of your conditions is NOT to use Java at all, then I cannot think of a way to generate this report. Has anybody solved this problem in a simple way? (by simple, I mean I don’t want to compile from source)Īll suggestions are welcome, including pointing me to packaged stand-alone report generator (important word here is “packaged”). In the end, I don(t know if this is a Fedora issue, an SQLite one, A LO one or some other. I also searched through LO extensions but it appears there’s nothing related to SQLite connector. However, for various reasons, I don’t want to install Java on my machine (anyway not knowing if I would succeed). Under “connector” jODBC, I can select any file, thus making SQLite DBs visible. ODBC Data Source: SQLite3 (but same behaviour wit SQLite – for SQLite v2)Īuthentication: none (as there is none in SQLite)įile selection dialog opens but only choice is ODF data base which will not display SQLite DB files.
![how to open sqlite database how to open sqlite database](https://codeunplug.com/wp-content/uploads/2019/03/output_b5EGTb.gif)
In order to connect to the database, I installed packages unixODBC and sqliteODBC, but when configuring access to said base with Base wizard: I want to generate summary report from an existing active SQLite DB. I searched through this site and googled without finding the appropriate fix. This is a duplicate/refresh of this old question because its answer is not satisfactory or outdated.
![how to open sqlite database how to open sqlite database](https://images.theposterdb.com/prod/public/images/posters/optimized/movies/1380/YHYqGaLDqtTwOyi7Ttw4dhtiFDF8Df4e76TpRFHx.jpg)
Config: LO 5.3.7.2, Linux 4.13, Fedora 26 (I have another “experimental” config under Fedora 27, but problem is the same)