Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 13 Aug 2003 13:57:27 -0400
From:      fkittred@gwi.net
To:        openoffice@freebsd.org
Subject:   problems with ODBC(Postgres) with StarOffice 6.0
Message-ID:  <200308131759.h7DHxHEL084875@pan.gwi.net>
In-Reply-To: Your message of "Fri, 04 Apr 2003 17:06:45 %2B0200." <20030404170601.V37965@cvs.imp.ch> 

next in thread | previous in thread | raw e-mail | index | archive | help

FreeBSD OS 4.8-stable
StarOffice 6.0
Postgres-odbc 7.2.5
iodbc 3.0.5

Hello;

	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.  

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.

Any suggestions?

regards,
fletcher



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200308131759.h7DHxHEL084875>