Обсуждение: Postgresql with OOo

Поиск
Список
Период
Сортировка

Postgresql with OOo

От
Art Fore
Дата:
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

От
Josh Berkus
Дата:
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

От
Giles Lean
Дата:
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

От
Michelle Konzack
Дата:
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