When “Tables” is selected, the options are:

'Tasks window (dependent on what is selected in the “Database” window).

In this example, we will save as “fosdem21_mariadb.odb”. Registration in this sense means that the database is viewable by other LibreOffice modules (like LibreOffice Calc and LibreOffice Writer). Provide a user name (and password if needed) and again check the connection (with the “Test Connection” button) and click “Next”:Īfter that, we have options to register the database. In order to connect to a running MariaDB server, choose “Connect to an existing database” and choose “ODBC” driver as shown below:Īfter that, choose DSN (the one that we created in the previous step) and click “Next”:

The default option is to create a new database, which is HSQLDB. Start Libreoffice Base from the terminal by running lobase (make sure to install the libreoffice-base package if needed).

Verify successful installation also using the isql utility, for example:.

Verify successful installation in the /.odbc.ini file.

Odbcinst -i -s -h -f MariaDB_odbc_data_source_template.ini A sample “MariaDB_odbc_data_source_template.ini” could be:

Create a template file for the Data Source Name (DSN).

USER DATA SOURCES.: /home/anel/.odbc.iniĭriver=/usr/lib/x86_64-linux-gnu/libmaodbc.so $ odbcinst -jįILE DATA SOURCES.: /etc/ODBCDataSources Verify successful installation in /etc/odbcinst.ini file (this path is obtained by the config info /-j/ option, where drivers are installed in that predefined location). $ sudo odbcinst -i -d -f MariaDB_odbc_driver_template.ini

Install the ODBC driver from the template file by running:.

Description = MariaDB Connector/ODBC v.3.1ĭriver = /usr/lib/x86_64-linux-gnu/libmaodbc.so

Libreoffice base online