Re: [INTERFACES] Problem of using Access '97 to open db

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