Creating a Contacts Database in OpenOffice: Page 2

(Page 2 of 3)

You need special drivers to connect to a MySQL or PostgreSQL database, or any other external database. In Debian (and the *buntu family and Mepis and all of its many offspring) you need the unixodbc package for ODBC support, plus the driver specific to your database:
  • odbc-postgresql for PostgreSQL
  • libmyodbc for MySQL
  • libsqliteodbc for sqlite
  • mdbtools for MS Access
  • tdsodbc for Sybase SQL and MS SQL
Another option for PostgreSQL is the openoffice.org-sdbc-postgresql package, which replaces both the ODBC and JDBC drivers.

You can also use the JDBC drivers:

  • openoffice.org-sdbc-postgresql
  • libpg-java for PostgreSQL
  • libmysql-java for MySQL

Fedora has different package names, and it does not include as many as Debian:

  • unixODBC.i386
  • postgresql-odbc.i386
  • mysql-connector-odbc.i386
  • postgresql-jdbc.i386
  • mysql-connector-java.i386
Any drivers that you can't find in your distribution can be downloaded from OpenOffice.org (see Resources), or from the vendor of your database. What's the difference between ODBC and JDBC drivers? There are some differences in speed and functionality. JDBC drivers are cross-platform, though I'm not sure why that should matter to anyone but developers. If you have problems connecting Base to an external database, try exporting just the data you want to use into a .csv file, and then import that into Base. Base loves correctly-formed delimited text files, and it's an easy hack for non-database gurus.

Page 2 of 3

Previous Page
1 2 3
Next Page

Tags: MySQL, Linux, Oracle, data, IT

0 Comments (click to add your comment)
Comment and Contribute


(Maximum characters: 1200). You have characters left.



IT Management Daily
Don't miss an article. Subscribe to our newsletter below.

By submitting your information, you agree that datamation.com may send you Datamation offers via email, phone and text message, as well as email offers about other products and services that Datamation believes may be of interest to you. Datamation will process your information in accordance with the Quinstreet Privacy Policy.