Date: Fri, 15 Aug 2003 11:54:14 +0200 (CEST) From: Martin Blapp <mb@imp.ch> To: fkittred@gwi.net Cc: openoffice@freebsd.org Subject: Re: problems with ODBC(Postgres) with StarOffice 6.0 Message-ID: <20030815115242.U38762@cvs.imp.ch>
next in thread | raw e-mail | index | archive | help
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@imp.ch> <mbr@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@freebsd.org> PGP Fingerprint: B434 53FC C87C FE7B 0A18 B84C 8686 EF22 D300 551E ------------------------------------------------------------------
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030815115242.U38762>