pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedunixODBC + PostgreSQL + StarOffice 5
3+ messages / 2 participants
[nested] [flat]
* unixODBC + PostgreSQL + StarOffice 5
@ 1999-05-18 20:24 Peter Harvey <pharvey@codebydesign.com>
0 siblings, 0 replies; 3+ messages in thread
From: Peter Harvey @ 1999-05-18 20:24 UTC (permalink / raw)
To: FreeODBC - News <freeodbc@as220.org>; pgsql-interfaces; +Cc: Jon Pounder <pounder@inline.net>; Nick Gorham <nick@easysoft.com>; Peter Gerhard <peter.gerhard@novasoft.de>; Bengt Hahn <mbha@approba.se>; Christian Kirsch <ck@ix.heise.de>; Daniel Brahneborg <basic@well.com>; Serge Torres <serge.torres@poste.cndp.fr>
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.
Attachments:
SQL.LOG (text/plain, 79.9K) download
^ permalink raw reply [nested|flat] 3+ messages in thread
* unixODBC - PostgreSQL - StarOffice 5
@ 1999-05-18 21:00 Peter Harvey <pharvey@codebydesign.com>
1999-05-18 21:26 ` Re: [INTERFACES] unixODBC - PostgreSQL - StarOffice 5 Byron Nikolaidis <byronn@solipsys.com>
0 siblings, 1 reply; 3+ messages in thread
From: Peter Harvey @ 1999-05-18 21:00 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] unixODBC - PostgreSQL - StarOffice 5
1999-05-18 21:00 unixODBC - PostgreSQL - StarOffice 5 Peter Harvey <pharvey@codebydesign.com>
@ 1999-05-18 21:26 ` Byron Nikolaidis <byronn@solipsys.com>
0 siblings, 0 replies; 3+ messages in thread
From: Byron Nikolaidis @ 1999-05-18 21:26 UTC (permalink / raw)
To: Peter Harvey <pharvey@codebydesign.com>; +Cc: 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.
Byron
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-05-18 21:26 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-05-18 20:24 unixODBC + PostgreSQL + StarOffice 5 Peter Harvey <pharvey@codebydesign.com>
1999-05-18 21:00 unixODBC - PostgreSQL - StarOffice 5 Peter Harvey <pharvey@codebydesign.com>
1999-05-18 21:26 ` Re: [INTERFACES] unixODBC - PostgreSQL - StarOffice 5 Byron Nikolaidis <byronn@solipsys.com>
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