Skip site navigation (1) Skip section navigation (2)

unixODBC + PostgreSQL + StarOffice 5

From: Peter Harvey <pharvey(at)codebydesign(dot)com>
To: FreeODBC - News <freeodbc(at)as220(dot)org>, pgsql-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Cc: Jon Pounder <pounder(at)inline(dot)net>, Nick Gorham <nick(at)easysoft(dot)com>, Peter Gerhard <peter(dot)gerhard(at)novasoft(dot)de>, Bengt Hahn <mbha(at)approba(dot)se>, Christian Kirsch <ck(at)ix(dot)heise(dot)de>, Daniel Brahneborg <basic(at)well(dot)com>, Serge Torres <serge(dot)torres(at)poste(dot)cndp(dot)fr>
Subject: unixODBC + PostgreSQL + StarOffice 5
Date: 1999-05-18 20:24:37
Message-ID: 3741CC85.CD4EE409@codebydesign.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
SitRep...

I have spent the day trying to get these guys to work together. I
started off not being able to even access the DM. Here is what I have
now...

1. can load and call DM now ( changed soffice start up script slightly)
2. can select a DSN from a list
3. can select table(s) from a list
4. can browse into StarOffice 'database' and see table icons

I had to make some changes to both the unixODBC DM and the PostgreSQL
driver to get this far.

BUT... I can not open a table (double click the icon) because StarOffice
send SQL that appears to be unsupported by PostgreSQL....

SELECT * FROM "postgres"."tbaddresses"

Any ideas on how to get past this?

I have attached the SQL.LOG if you want more info.

Peter Harvey

BTW: I have been told that the MySQL driver works fine with StarOffice
but I have yet to try it.



Attachment: SQL.LOG
Description: text/plain (79.9 KB)

pgsql-interfaces by date

Next:From: Peter HarveyDate: 1999-05-18 21:00:57
Subject: unixODBC - PostgreSQL - StarOffice 5
Previous:From: Eildert GroeneveldDate: 1999-05-18 09:05:45
Subject: Postmaster getting veeeery big

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group