| From: | Info Agipa <info(at)apli-agipa(dot)com> |
|---|---|
| To: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | MS-QUERY / Postgresql ODBC driver incompatibility |
| Date: | 2013-11-05 13:00:31 |
| Message-ID: | ADFDC855B3DED14E844ABDEF735A65875041C1FAD5@APLIEX01.exchange.apli.local |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Hello.
I've found a problem in using the postgresql ODBC driver with MS-QUERY.
MS-Query is the tool included in Microsoft Office to access db in excel.
If I type in ms-query :
select code as groupe_clients, libelle
from groupes_clients
I have an error message. After some search, it appears that postgresql receive :
select code as 'groupe_clients', libelle
from groupe_clients
But postgresql don't want ' but double quote " in the as part.
MS-Query doesn't include a parameter to change this.
It seems to be a ms-query bug...
If no solution exists, I think it's a good idea to include an alert in the faq (http://psqlodbc.projects.pgfoundry.org/faq.html)
As I have searching for a loooong time on google to see what I can make to fix this.
Am I the only one wich access to postgresql in excel using ms-query and with as clause ?
my ODBC driver version : 8.03.02.00
my PostgreSQL database version : 8.4.16
Thanks for your attention.
Sylvain Fauveau
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2013-11-05 22:19:14 | Re: MS-QUERY / Postgresql ODBC driver incompatibility |
| Previous Message | Inoue, Hiroshi | 2013-11-05 09:01:00 | Re: Configuration error in psqlodbc-09.02.0100 . Help needed! |