unixODBC - PostgreSQL - StarOffice 5
| От | Peter Harvey |
|---|---|
| Тема | unixODBC - PostgreSQL - StarOffice 5 |
| Дата | |
| Msg-id | 3741D509.F9203357@codebydesign.com обсуждение исходный текст |
| Список | 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
В списке pgsql-interfaces по дате отправления: