Just an FYI:
Some of the distributions disable the Java support inside their version of
OpenOffice. This is mainly due to licensing issues, but it affects several
functions. For the easiest installation, download and install a JRE and get it
working properly. I.e., you can run java programs from the command line and, if
desired, from your browser. Test your JDBC connectivity. If you want ODBC, install
it and test it against your backend database.
Finally, grab the OpenOffice 2.x installation from the OpenOffice.org site. If the
previous ODBC and JDBC tests worked then the OpenOffice connector will almost
certainly have no problems connecting.
Caveats:
1) As mentioned, verify that your distribution doesn't disable java support. If
you're using an RPM based distro, you can download the SRC.RPM and take a look at
the spec file for the configuration options. For Gentoo, Debian, and other
source-based distros, take a look at your build options. Otherwise just grab the
vanilla openoffice from the main website.
2) Verify that your firewall allows access to the database ports.
3) Verify that you can connect from the mysql-client to the server.
No, it's not going to work without some elbow grease, but I was able to get it going
in a couple hours.
-- * The Digital Hermit http://www.digitalhermit.com * Unix and Linux Solutions kwan@digitalhermit.com ----------------------------------------------------------------------- This list is provided as an unmoderated internet service by Networked Knowledge Systems (NKS). Views and opinions expressed in messages posted are those of the author and do not necessarily reflect the official policy or position of NKS or any of its employees.
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 20:24:06 EDT