From owner-freebsd-openoffice@FreeBSD.ORG  Wed Aug 13 10:59:19 2003
Return-Path: <owner-freebsd-openoffice@FreeBSD.ORG>
Delivered-To: freebsd-openoffice@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 0B7BF37B401
	for <openoffice@freebsd.org>; Wed, 13 Aug 2003 10:59:19 -0700 (PDT)
Received: from pan.gwi.net (pan.gwi.net [207.5.128.165])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 4A26043F93
	for <openoffice@freebsd.org>; Wed, 13 Aug 2003 10:59:18 -0700 (PDT)
	(envelope-from fkittred@gwi.net)
Received: from nexus.gwi.net (blake.gwi.net [207.5.142.8])
	by pan.gwi.net (8.12.6p2/8.12.6) with ESMTP id h7DHxHEL084875
	for <openoffice@freebsd.org>; Wed, 13 Aug 2003 13:59:17 -0400 (EDT)
	(envelope-from fkittred@gwi.net)
Message-Id: <200308131759.h7DHxHEL084875@pan.gwi.net>
To: openoffice@freebsd.org
From: fkittred@gwi.net
In-Reply-To: Your message of "Fri, 04 Apr 2003 17:06:45 +0200."
             <20030404170601.V37965@cvs.imp.ch> 
Date: Wed, 13 Aug 2003 13:57:27 -0400
Subject: problems with ODBC(Postgres) with StarOffice 6.0
X-BeenThere: freebsd-openoffice@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Porting OpenOffice to FreeBSD <freebsd-openoffice.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-openoffice>,
	<mailto:freebsd-openoffice-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-openoffice>
List-Post: <mailto:freebsd-openoffice@freebsd.org>
List-Help: <mailto:freebsd-openoffice-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-openoffice>,
	<mailto:freebsd-openoffice-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 13 Aug 2003 17:59:19 -0000


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