Just released is the MySQL Connector for OpenOffice.org 1.0. This OpenOffice.org extension allows Sun's open source office suite to be connected to a MySQL server, versions 5.1 and later. This driver is compatible with OpenOffice.org 3.1.1, StarOffice 9.1, StarSuite 9.1 or newer, including the upcoming OpenOffice.org 3.2.

Frank Schoenheit explains the advantages MySQL Connector for OpenOffice.org 1.0 has over MySQL Connector/ODBC or MySQL Connector/J as:

• Easy installation through the OpenOffice.org Extension Manager
• Seamless integration into OpenOffice.org
• Work on multiple MySQL schemata (databases) simultaneously
• Connect to MySQL servers using named pipes (Windows) or Sockets (Unix)
• No need to go through an additional Connector installation routine (ODBC/JDBC)
• No need to configure or register an additional connector (ODBC)
• No need to install or configure a driver manager (ODBC)
• No need for a Java Runtime Environment (JDBC)

Offered in versions for Windows, Linux Intel 32 and 64 bit, Solaris SPARC, Solaris Intel, and Mac OS X Intel, MySQL Connector for OpenOffice.org 1.0 is based on Connector/C++ and Connector/C.

The one cautionary note is that if a connection is set up to a MySQL server outside an intranet, which is known by IP address, it might fail with an error code of 10060, effectively saying "Can't connect". This is a known issue. Schoenheit explains, "Fixing it would require upgrading to a new Connector/C version, which is not yet available. So we decided to release 1.0 despite of this known problem, since we're convinced that Connector/OpenOffice.org has nonetheless production quality, and can give you great advantages over using Connector/ODBC or Connector/J."

More Information

Download

Wiki

OpenOffice.org Extensions

MySQL Connector for OpenOffice.org 1.0 - Known Issues

MySQL Connector for OpenOffice.org 1.0 GA - GullFOSS blog entry by Schoenheit [...read more...]

		fullsource
Print Email Current Profile Archive Blog Generate newsletter