Обсуждение: Problem of using Access '97 to open db

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.
Howdoes it fixed with this ? 

Thanks for attention and any suggestions and solutions will be highly appreciated.

regards,
MICHAEL

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.
Howdoes 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