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
0 kommentar(er)
