From: Byron Nikolaidis <byronn@solipsys.com>
To: Peter Harvey <pharvey@codebydesign.com>
Cc: pgsql-interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] unixODBC - PostgreSQL - StarOffice 5
Date: Tue, 18 May 1999 17:26:37 -0400
Message-ID: <3741DB0D.97144860@solipsys.com> (raw)
References: <3741D509.F9203357@codebydesign.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@solipsys.com, pharvey@codebydesign.com
Subject: Re: [INTERFACES] unixODBC - PostgreSQL - StarOffice 5
In-Reply-To: <3741DB0D.97144860@solipsys.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox