How do I connect OpenOffice to a PostgreSQL database?
Have a look at this Newsforge article for details. The article is oriented to a Linux installation but should be adaptable to a Windows environment with little change. A few tips: 1. The SDBC driver is an alpha version, this means it might not be so stable in your case. You were warned!! See the driver page for more details. [This driver has worked so far ok for me: Slackware Linux v10.0 and OOo 1.1.3] 2. There are postgresql ODBC drivers available for download at the postgresql ftp site. The driver for Linux needs to be compiled from the source tar.gz file (around 0.4MB download) and requires also the unixODBC connector installed for a Linux installation. The downloadable Windows driver (zip) files exist as full or msi versions. The difference is that the full version comes with the Microsoft installer and is consequently much bigger (3.25Mb for the zip file as compared with 0.5MB for the msi zip file). 3. If your postgresql server is running with (for example) username postgres, make
