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 appropriape 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 MySQL libraries (MySQL-shared-...) MyODBC software on the workstation

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      =
Edit | Attach | Print version | History: r6 | r4 < r3 < r2 < r1 | Backlinks | View wiki text | Edit WikiText | More topic actions...
Topic revision: r3 - 14 Apr 2004, ColeBeck
 

This site is powered by FoswikiCopyright © 2013-2022 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Vanderbilt Biostatistics Wiki? Send feedback