Postgres Pro
Downloads
Home   >   mailing lists

Problem of using Access '97 to open db - Mailing list pgsql-interfaces

From Michael Yeung
Subject Problem of using Access '97 to open db
Date
Msg-id 01BDB987.F8FA2AF0@wynyard.alphanet.net.au
Whole thread Raw
List pgsql-interfaces
Tree view 
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

pgsql-interfaces by date:

Previous
From: Aleksey Demakov
Date:
Subject: large objects
Next
From: Pap Tibor
Date:
Subject: Re: [INTERFACES] JDBC compile error