Thread: unixODBC - PostgreSQL - StarOffice 5
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
Peter Harvey wrote: > 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" > Is there anything else in SQLGetInfo that has to do with owner? Try changing these or commenting them out and see if it does anything. Byron