OK tried these, but seem to be more MySQL related. Is there not a
PostgreSQL/OO guru on this list?
Scott
----- Original Message -----
From: "J M Okomba" <Okomba@kabage.co.ke>
To: <pgsql-jdbc@postgresql.org>
Sent: Tuesday, January 21, 2003 3:35 PM
Subject: Re: [JDBC] Open Office
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
