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\java
\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