| 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 |
| 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 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 | Content-Type | Size |
|---|---|---|
| SQL.LOG | text/plain | 79.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Harvey | 1999-05-18 21:00:57 | unixODBC - PostgreSQL - StarOffice 5 |
| Previous Message | Eildert Groeneveld | 1999-05-18 09:05:45 | Postmaster getting veeeery big |