Date: Wed, 13 Aug 2003 15:12:54 -0400 From: fkittred@gwi.net To: fkittred@gwi.net Cc: openoffice@freebsd.org Subject: Re: problems with ODBC(Postgres) with StarOffice 6.0 Message-ID: <200308131914.h7DJEiPh047486@aphrodite.gwi.net> In-Reply-To: Your message of "Wed, 13 Aug 2003 13:57:27 EDT." <200308131759.h7DHxHEL084875@pan.gwi.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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?200308131914.h7DJEiPh047486>