MySQL tools
- mysqlnavigator - use apt-get install mysql-navigator
Using OpenOffice as a front end to MySQL database using ODBC
OpenOffice is running on user's workstation. MySQL database is running on a server computer elsewhere. We assume that MySQL is configured to accept connections from appropriate people and locations.
- make sure MySQL client is installed - use apt-get install mysql-client
- this may very well add 8 new packages (libdbd-mysql-perl, libdbi-perl, libmysqlclient12, libnet-daemon-perl, libplrpc-perl, mysql-client, mysql-common, mysql-doc), update 4 packages (libperl, perl, perl-base, perl-modules), and remove one package (perl-doc)
- install ODBC software on workstation - use apt-get install unixodbc
- install MyODBC software on the workstation (alternatively, use apt-get install libmyodbc)
- gunzip MyODBC*.tar.gz
- tar xvf MyODBC*.tar
- cd MyODBC*
- cp libmyodbc3* /usr/local/lib
- cp odbc.ini /usr/local/etc
- cd /etc
- edit odbc.ini & odbcinst.ini
- run OpenOffice and setup the datasource
- Tools -> Data Sources...
- click New Data Source
- enter DatabaseServer for name
- pick ODBC for database type
- select DatabaseServer from data source URL
- click the ODBC tab and configure as necessary
configuration files in /home/dalep
.my.cnf (configuration file for connection to database)
[client]
host=biostat.mc.vanderbilt.edu
user=dalep
password=********
.odbc.ini (defines what OpenOffice calls "data sources". one [section] for each source)
[DatabaseServer]
Description = Biostatistics Database Server
Driver = MySQL
Server = biostat.mc.vanderbilt.edu
Database = test
Port = 3306
Socket =
Option =
Stmt =