Connect MySQL and Base

From Apache OpenOffice Wiki
Revision as of 19:43, 21 October 2007 by JZA (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Here is a tutorial to connect MySQL database with OpenOffice.org Base.


Using JDBC on Windows

Using ODBC on GNU/Linux

Using JDBC on Linux

Using ODBC on Linux

Recommendations settings

Known issues regarding MySQL and OpenOffice.org can be avoided by having specific settings here are some of those:

MySQL settings

  • Make sure that MySQL is using TCP/IP as opposed to sockets. Edit the my.cnf file at /etc/ and comment skip-networking

OpenOffice.org settings

  • OpenOffice.org uses Java for JDBC, please make sure you have JRE at Tools - Options - OpenOffice.org General - Java
  • Declare the mysql-connector-j.bin at the classpath at Tools - Options - OpenOFfice.org General - Java


Categories: Database

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Connect_MySQL_and_Base&oldid=50949"
Personal tools