Thank you. I'll see if I can get that going. I finally got ODBC working and make some notes here for others who may search in the future. I simply updated the /etc/unixODBC in files per the specs on the unixODBC site - although another part of their site says postgres doesn't use these ini files! I also found that Gentoo does not have an ODBCConfig - it makes it gODBCConfig and you have to enable the gnome flag for it to be built.
I'll see if I can get JDBC working now. Thanks. On Saturday September 16 2006 02:38, Mark Kirkwood wrote: > 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 -- Brett I. Holcomb -- gentoo-user@gentoo.org mailing list