Date: Fri, 15 Aug 2003 10:31:22 -0400 From: fkittred@gwi.net To: Martin Blapp <mb@imp.ch> Cc: openoffice@freebsd.org Subject: Re: problems with ODBC(Postgres) with StarOffice 6.0 Message-ID: <200308151433.h7FEXGPh015392@aphrodite.gwi.net> In-Reply-To: Your message of "Fri, 15 Aug 2003 11:54:14 %2B0200." <20030815115242.U38762@cvs.imp.ch>
next in thread | previous in thread | raw e-mail | index | archive | help
On Fri, 15 Aug 2003 11:54:14 +0200 (CEST) Martin Blapp wrote: > http://projects.imp.ch/openoffice ... OK, I downloaded and installed openoffice-1.0.3_2. I have the same problems. Any debugging suggestions would be gratefully accepted. regards, fletcher On Wed, 13 Aug 2003 13:57:27 -0400 fkittred@gwi.net wrote: > 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 Sorry, here is my ~/.odbc.ini file: [ODBC Data Sources] Lines = Lines and Circuits Database [Lines] DSN=Lines Driver = /usr/local/lib/psqlodbc.so Servername = devtest Database = lines Servertype = postgres Username = fkittred Port = 5432 Trace = ON TraceFile = stdout Password = Protocol = 7.2 FetchBufferSize = 99 ReadOnly = No RowVersioning = No ShowSystemTables = No ShowOidColumn = No FakeOidIndex = No ConnSettings = CommLog = 1 [Default] Driver = /usr/local/lib/psqlodbc.so [ODBC] InstallDir = /usr/local/lib/libiodbc.so
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200308151433.h7FEXGPh015392>