problems with ODBC(Postgres) with StarOffice 6.0

[Martin Blapp]

Hi.

> 	I am back to using StarOffice 6.0 due to an inability to
> build any recent versions of OpenOffice.  But that is not what this
> message is about.  It is about trying to access a remote postgres
> database from StarOffice via ODBC.

http://projects.imp.ch/openoffice ...

> I installed /usr/ports/databases/postgres-odbc which in turn installed
> iodbc.  After a half day of futzing around, I got a ~/.odbc.ini that
> worked at least with the libiodbc-3.0.5/samples/odbctest program.  I
> can connect via odbc to the remote database.  However, when I start
> soffice, go to Tools->Data Sources, select database type of "ODBC" and
> then try to browse, I get "Could not load the program library
> libodbc.so or it is corrupted".  I have created symlinks to
> "/usr/local/lib/psqlodbc.so" called /usr/lib/libodbc.so and
> /usr/local/lib/libodbc.so.  Neither seemed to work.

You cannot use a linux version of office (staroffice is linux only)
and try to use freebsd odbc libs. Install the linux odbc libs, then
it will work.

Martin

Martin Blapp, <mb at imp.ch> <mbr at FreeBSD.org>
------------------------------------------------------------------
ImproWare AG, UNIXSP & ISP, Zurlindenstrasse 29, 4133 Pratteln, CH
Phone: +41 61 826 93 00 Fax: +41 61 826 93 01
PGP: <finger -l mbr at freebsd.org>
PGP Fingerprint: B434 53FC C87C FE7B 0A18 B84C 8686 EF22 D300 551E
------------------------------------------------------------------