| 1 |
Thank you. I'll see if I can get that going. I finally got ODBC working and |
| 2 |
make some notes here for others who may search in the future. I simply |
| 3 |
updated the /etc/unixODBC in files per the specs on the unixODBC site - |
| 4 |
although another part of their site says postgres doesn't use these ini |
| 5 |
files! I also found that Gentoo does not have an ODBCConfig - it makes it |
| 6 |
gODBCConfig and you have to enable the gnome flag for it to be built. |
| 7 |
|
| 8 |
I'll see if I can get JDBC working now. |
| 9 |
|
| 10 |
Thanks. |
| 11 |
|
| 12 |
|
| 13 |
On Saturday September 16 2006 02:38, Mark Kirkwood wrote: |
| 14 |
> Brett I. Holcomb wrote: |
| 15 |
> > I've installed postgres and am trying to get it to work with OpenOffice |
| 16 |
> > 2.0.3. After searching the web, postgres sites, unixODBC site, etc. I |
| 17 |
> > still haven't figured out how to get ODBC and JDBC to see postgres. How |
| 18 |
> > do I setup ODBC and JDBC so that my postgres databases are available? |
| 19 |
> > Any docs, hints, etc. would be appreciated. |
| 20 |
> |
| 21 |
> I'm not sure about ODBC, but for JDBC the general instructions are: |
| 22 |
> |
| 23 |
> 1/ ensure that the CLASSPATH includes the driver jar (e.g. |
| 24 |
> CLASSPATH=.:/usr/local/pgsql/share/postgresql.jar) |
| 25 |
> |
| 26 |
> 2/ Check that postgres server has listen_address='*' in its |
| 27 |
> configuration file (postgresql.conf) |
| 28 |
> |
| 29 |
> 3/ Set the connection url for the database you want (e.g. |
| 30 |
> jdbc:postgresql://localhost:5432/postgres to connect to a server using |
| 31 |
> port 5432 and a database called postgres) |
| 32 |
> |
| 33 |
> Presumably openoffice lets you tell it 1/ and 3/, its up to you to make |
| 34 |
> sure of 2/ ! |
| 35 |
> |
| 36 |
> Cheers |
| 37 |
> |
| 38 |
> Mark |
| 39 |
|
| 40 |
-- |
| 41 |
|
| 42 |
Brett I. Holcomb |
| 43 |
-- |
| 44 |
gentoo-user@g.o mailing list |
Archives