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

Re: [INTERFACES] unixODBC - PostgreSQL - StarOffice 5

From: Byron Nikolaidis <byronn(at)solipsys(dot)com>
To: Peter Harvey <pharvey(at)codebydesign(dot)com>
Cc: pgsql-interfaces <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] unixODBC - PostgreSQL - StarOffice 5
Date: 1999-05-18 21:26:37
Message-ID: (view raw or whole thread)
Lists: pgsql-interfaces
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.


In response to

pgsql-interfaces by date

Next:From: Matthew HagertyDate: 1999-05-19 00:39:41
Subject: Problems with money fields.
Previous:From: Peter HarveyDate: 1999-05-18 21:00:57
Subject: unixODBC - PostgreSQL - StarOffice 5

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