pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedProblem of using Access '97 to open db
2+ messages / 2 participants
[nested] [flat]
* Problem of using Access '97 to open db
@ 1998-07-27 07:57 Michael Yeung <michaely@alphanet.net.au>
1998-07-27 13:36 ` Re: [INTERFACES] Problem of using Access '97 to open db Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 1 reply; 2+ messages in thread
From: Michael Yeung @ 1998-07-27 07:57 UTC (permalink / raw)
To: pgsql-interfaces
hi all,
I have linked the postgresql dB through ODBC Drivers from www.insightdist.com !
Then i use Access 97 to open the database and the error says
'Error while executing query; WARN :parser : parse error at or near """ '
I checked the log and discover that the SELECT statement with double quote around the table name and the field name. How does it fixed with this ?
Thanks for attention and any suggestions and solutions will be highly appreciated.
regards,
MICHAEL
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] Problem of using Access '97 to open db
1998-07-27 07:57 Problem of using Access '97 to open db Michael Yeung <michaely@alphanet.net.au>
@ 1998-07-27 13:36 ` Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 0 replies; 2+ messages in thread
From: Byron Nikolaidis @ 1998-07-27 13:36 UTC (permalink / raw)
To: Michael Yeung <michaely@alphanet.net.au>; +Cc: pgsql-interfaces
Michael Yeung wrote:
>
> hi all,
>
> I have linked the postgresql dB through ODBC Drivers from www.insightdist.com !
>
> Then i use Access 97 to open the database and the error says
>
> 'Error while executing query; WARN :parser : parse error at or near """ '
>
> I checked the log and discover that the SELECT statement with double quote around the table name and the field name. How does it fixed with this ?
>
Postgres (at least 6.3.2) supports double quotes around identifiers.
This allows for embedded spaces and other characters to be used in table
names and field names. Therefore, at least under 6.3.2, something like
select "test1"."a" from "test1" is perfectly legal.
For ODBC, the driver now returns " as the identifier quote character.
Access then uses this character for identifiers.
Are you using an earlier version of Postgres that perhaps didn't support
quotes?
If 6.2 postgres doesn't support quotes, I could easily patch the driver
to not use quotes when using 6.2 protocol.
Please let me know.
Byron
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1998-07-27 13:36 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-07-27 07:57 Problem of using Access '97 to open db Michael Yeung <michaely@alphanet.net.au>
1998-07-27 13:36 ` Byron Nikolaidis <byronn@insightdist.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