Check http://www.itworld.com/nl/lnx_desktop/09052002/?idgnet
and http://documentation.openoffice.org/HOW_TO/data_source/data1_EN.html
The MySQL example at http://kienlein.com/pages/mysql-jdbc-howto-en.html
could also help
> -----Original Message-----
> From: Scott Taylor [SMTP:scott.taylor@4i-dotcom.com]
> Sent: 21 January 2003 13:49
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] Open Office
>
> I wonder whether anyone could either point me to some decent documentation
> on connecting to Open Office, or correct the information below from the
> Datsources box in OO.
>
> Name: PostgreSQL
> Database Type: JDBC
> URL: jdbc:postgresql://localhost:5432/recruitment
>
> Driver Class: org.postgresql.Driver
> Username: Scott
> Password: check
> Character: system
>
> I have version 7.3.1 (Cygwin on 98) and the driver pg73jdbc3.jar is in my
> classpath as follows:
>
> SET
> CLASSPATH=C:\j2sdk1.4.1_01\lib\tools.jar;C:\cygwin\usr\share\postgresql\ja
> va
> \pg73jdbc3.jar
>
> I have also set TCP/IP sockets =true and have trust for authentication
>
> I am getting the following errors in OO:
>
> 1. No connection could be established for the URL
> jdbc:postgresql://localhost:5432/recruitment.
>
> 2. Connection refused. Check that the hostname and port are correct and
> that
> the postmaster is accepting TCP/IP connections.
>
> 3. Please check the current settings, e.g. user name and password.
>
> Thanks
>
> Scott
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org