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

unixODBC - PostgreSQL - StarOffice 5

From: Peter Harvey <pharvey(at)codebydesign(dot)com>
To: pgsql-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: unixODBC - PostgreSQL - StarOffice 5
Date: 1999-05-18 21:00:57
Message-ID: 3741D509.F9203357@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 noticed that SQLTables and
SQLColumns avoids returning owner because of having similar problem with
MS Access.

I know StarOffice is getting the login id using a call to SQLGetInfo but
if I comment this out then I get...

SELECT * FROM ""."tbaddresses"

Help!

Peter Harvey




Responses

pgsql-interfaces by date

Next:From: Byron NikolaidisDate: 1999-05-18 21:26:37
Subject: Re: [INTERFACES] unixODBC - PostgreSQL - StarOffice 5
Previous:From: Peter HarveyDate: 1999-05-18 20:24:37
Subject: unixODBC + PostgreSQL + StarOffice 5

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