Comments - LibreOffice Base
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Hi Anel,
Thank you for responding.
I removed ODBC connectors from my computer. Then, I worked on connecting through JDBC.
I was able to set up LOBase with a JDBC connector by downloading mariadb-java-client and mysql-connector-java using YAST (I am running a current version of Opensuse Tumbleweed) and then following this basic set of instructions http://www.giustetti.net/wiki/index.php?title=Connect_libreoffice_to_mariadb.
However, after I fumbled my way through to get relationships working, I found that I could not set my tables properly with auto-increment. I stopped there realizing that I may had solved my problem with ODBC.
I deleted my JDBC odb files, reinstalled both mariadb-connector-odbc and unixodbc using YAST. I did NOT install unixodbc-dev or odbcinst (odbcinst is part of unixodbc_and openssh was already installed. I followed instruction for ini files.
I opened LOBase and follow the path of -- Open LOBase -> connect to an existing database -> MySQL -> Connect using ODBC -> etc. This brought me back to the same problem of Relationships not working. (I already had created mariadb databases and input users from a command line.)
I then went in to edit each table to match the foreign key Field Types to the same Field Type as the primary keys. I had used Field Type Integer[MEDIUMINT] with 7 characters for my primary keys. With Primary and Foreign Key Type Fields matching, Relationships worked with the ODBC connector.
So, to have the instructions you presented on this page work, I had 3 problems that when resolved had tables, auto-increment and Relationships working. These may be common sense to you, but as I am starting out with mariadb, LOBase, and ODBC, this was a learning curve for me:
1. use only letters and numbers in database names - DO NOT use underscores. 2. when "connecting to an existing database", select MySQL and then at the next choice, chose "Connect using ODBC". 3. Ensure that Field Types and character lengths of your Primary and Foreign Keys match BEFORE attempting to create relationships.
Give this a try and see if it works for you. I will slowly begin to get forms running, then queries, and finally reports. I will stop with JDBC at this time, but note that Relationships were working with it but there were a few other kinks still to address.
Thank you for your help