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.
Anel, thank you for responding.
I do agree that mariadb appears to be functioning for me. However, I also have Libreoffice base functioning well for me with its embedded HSQLDB. The problem at hand is the connection between Base and mariadb.
With no offence intended, Mariadb. com is advancing LO Base as a GUI for mariadb. In fact, these comments are on the Mariabd.com page for using an ODBC connector for Base to access mariadb. In that regard, there needs to be some degree of support to ensure that connection works. How that support comes about is not at issue, however I need to access to that support or knowledge base.
I have gone back and reset my connection to mariadb using an ODBC in an alternate manner as suggested by JDBC connector support. Open Base -> connected to an existing database -> MySQL -> Connect using ODBC -> etc. instead of choosing ODBC initially. This resolve problems with creating tables with auto increment and being able to edit tables after they are created. I am also able to select Tools -> Relationships and add tables BUT I cannot create relations either by dragging or by selecting "New Relations".
I am aware that you, Anel, are an accomplished programmer, and I am not. It is precisely that reason why I (and others) need a help.
There is still something missing from the instructions on this page to create a functioning ODBC connection. What am I missing ..... or if there is a problem with ODBC connections, where are there 'current' detailed instructions/information on connecting mariadb with Base using a JDBC connection? Information you linked me to was out of date.
Thank you for your help, Richard caid.ca