Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgresql with OOo

Postgresql with OOo

From
Art Fore
Date:
Have two questions on this subject:

1.    Which would be better to connect OpenOffice.org 1.02 to a postgresql
database, JDBC or ODBC?

2.    Has anyone connected OOo to a postgresql database, and if so, could
you point me in the direction of some howtos for this/

System is SuSE 8.1 and 8.0.

Art

Re: Postgresql with OOo

From
Josh Berkus
Date:
Art,

> 1.    Which would be better to connect OpenOffice.org 1.02 to a postgresql
> database, JDBC or ODBC?

I'm using unixODBC -- I had all kinds of issues trying to use JDBC.

> 2.    Has anyone connected OOo to a postgresql database, and if so, could
> you point me in the direction of some howtos for this/

There's a HOWTO for OOo+JDBC+MySQL, which could as easily be adapted for
PostgreSQL:

http://www.ooodocs.org/modules.php?name=Content&pa=showpage&pid=15

And another for unixODBC:

http://www.unixodbc.org/  ---> manual


--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

Re: Postgresql with OOo

From
Giles Lean
Date:
Art Fore wrote:

> 1.    Which would be better to connect OpenOffice.org 1.02 to a postgresql
> database, JDBC or ODBC?
>
> 2.    Has anyone connected OOo to a postgresql database, and if so, could
> you point me in the direction of some howtos for this/

I'm looking at connecting by implementing a SDBC driver, but this is
early days -- I fear sorting out the open office build and identifying
what needs to be written will take more time than actually writing it,
but I'll see.

Ideas and input welcome from anyone, by the way.  I volunteered 'cos
it seemed interesting and there was a lack of volunteers, not because
I knew what I was letting myself in for. ;-)

Regards,

Giles

Re: Postgresql with OOo

From
Michelle Konzack
Date:
Hello Art,

Am 20:12 2003-01-28 -0800 hat Art Fore geschrieben:
>
>Have two questions on this subject:
>
>1.    Which would be better to connect OpenOffice.org 1.02 to a postgresql
>database, JDBC or ODBC?

I use ODBC because it is much lighter (with StarOffice 5.2) because I need
to run the stuff on K6-III/500MHz which are older Office-Workstations.

>2.    Has anyone connected OOo to a postgresql database, and if so, could
>you point me in the direction of some howtos for this/

Curently not, because it give me some trouble...
But I am working on it.

>System is SuSE 8.1 and 8.0.

I use Debian GNU/Linux 3.0r0 Woody

>Art

Thanks
Michelle