![]() The are two files needed in /etc folder - ‘odbc.ini’ & ‘odbcinst.ini’. Have not been able to find a JDBC driver which works for me so all is based upon ODBC for the connection. 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. ![]() 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. Config: LO 5.3.7.2, Linux 4.13, Fedora 26 (I have another “experimental” config under Fedora 27, but problem is the same) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |