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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Byron Nikolaidis | 1999-05-18 21:26:37 | Re: [INTERFACES] unixODBC - PostgreSQL - StarOffice 5 |
Previous Message | Peter Harvey | 1999-05-18 20:24:37 | unixODBC + PostgreSQL + StarOffice 5 |