OpenOffice 2.3, PostgreSQL 8.2, postgresql-odb: not working!
ohartman at zedat.fu-berlin.de
Wed Dec 5 02:12:40 PST 2007
First, please reply also to my eMailaddress as I'm not member of this
list. Thank you very much in advance.
I run a bunch of FreeBSD 7.0-BETA4 boxes, all with OpenOffice 2.3,
PostgreSQL 8.2 and postgresql-odbc (all most recent builds from the ports).
My databases are about to migrate from MySQL to PostgreSQL and if this
has been done, MySQL is about to be deleted. On MySQL connections from
OpenOffice of any kind in conjunction wih the mysql-connector-odbc
(unixODBC based) works well with the MySQL 5.0 server backend.
But with PostgreSQL I have much trouble! When building postgresql-odbc
with iODBC as standard in the port, connections do fail at the base,
even with global odbc.ini/odbcinst.ini and ~/.odbc.ini. I rejected iODBC
and installed postgresql-odbc with unixODBC instead (it is much better
I try to access a database from OpenOffice choosing ODBC with both MySQL
and PostgreSQL and proper settings for the data sources in my
~/.odbc.ini, but with connections to PostgreSQL I receive an empty
errorlike box (with MySQL, in a similar box is the Error-Message from
the underlying ODBC driver presented, but this one is without text and
only OK button present). Connections never succeed.
Even with a proper setup of users in PostgreSQL or with a loose bunch of
users able to connect from everywhere without passwords it does not work
and drives my crayzy :-(
Connecting from localhost and remotely host via 'psql' client works
well, so I suspect the ODBC driver is faulty, somehow.
OpenOffice Howtos, both in English and German, do have a kind of
tutorial how to connect to Postgres via ODBC and I wonder this works for
all of us working with FreeBSD/PostgreSQl/OpenOffice.
I also have another PostgreSQL server, running our databases at the
facility on a CentOS driven server system, PostgreSQL 8.1 and this also
drops every attempt to connect, even I can connect to this server with
pgAdmin and psql, either.
So, what is wrong? Am I a kind of blocked, stupid or something? I
appreciate any help and hint and would present config files if necessary.
More information about the freebsd-openoffice