Fw: Open Office

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(at)kabage(dot)co(dot)ke>
To: <pgsql-jdbc(at)postgresql(dot)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(dot)taylor(at)4i-dotcom(dot)com]
> > Sent: 21 January 2003 13:49
> > To: pgsql-jdbc(at)postgresql(dot)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(at)postgresql(dot)org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html