![]() "Tables" window - shows list of tables that are created.Īs we can see, there are system tables in the “mysql” database as well as “test” database. ![]() 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
0 Comments
Leave a Reply. |