Brett I. Holcomb wrote:
I've installed postgres and am trying to get it to work with OpenOffice 2.0.3.
After searching the web, postgres sites, unixODBC site, etc. I still haven't
figured out how to get ODBC and JDBC to see postgres. How do I setup ODBC and
JDBC so that my postgres databases are available? Any docs, hints, etc.
would be appreciated.
I'm not sure about ODBC, but for JDBC the general instructions are:
1/ ensure that the CLASSPATH includes the driver jar (e.g.
CLASSPATH=.:/usr/local/pgsql/share/postgresql.jar)
2/ Check that postgres server has listen_address='*' in its
configuration file (postgresql.conf)
3/ Set the connection url for the database you want (e.g.
jdbc:postgresql://localhost:5432/postgres to connect to a server using
port 5432 and a database called postgres)
Presumably openoffice lets you tell it 1/ and 3/, its up to you to make
sure of 2/ !
Cheers
Mark
--
[email protected] mailing list
