There’s an article here that explains how to connect to a mysql database from OpenOffice.org Base using odbc, but the author makes it sound like rocket science. It’s easy – summary:
-
sudo aptitude install unixodbc libmyodbc unixodbc-bin
-
sudo ODBCConfig
- driver is /usr/lib/odbc/libmyodbc.so
- setup is /usr/lib/odbc/libodbcmyS.so
- run the wizard, connect using the saved odbc configuration
