[gentoo-user] Postgresql ODBC and JDBC in Gentoo

[gentoo-user] Postgresql ODBC and JDBC in Gentoo

[Brett I. Holcomb]

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.


-- 

Brett I. Holcomb
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] Postgresql ODBC and JDBC in Gentoo

[Mark Kirkwood]

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
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] Postgresql ODBC and JDBC in Gentoo

[Mark Kirkwood]

Mark Kirkwood wrote:
>
> 2/ Check that postgres server has listen_address='*' in its 
> configuration file (postgresql.conf)
> 
>

Should be listen_addresses='*'. Sorry.
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] Postgresql ODBC and JDBC in Gentoo

[Brett I. Holcomb]

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