Skip site navigation (1) Skip section navigation (2)

Re: Problem with simple SELECT over ODBC

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Werner Kuhnle" <wek(at)kuhnle(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Problem with simple SELECT over ODBC
Date: 2010-09-03 14:35:56
Message-ID: 22386.1283524556@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-odbc
"Werner Kuhnle" <wek(at)kuhnle(dot)com> writes:
> But when exactly the same SELECT is issued to PG over the PG ODBC driver then I get :

> SQLRetcode=-1
> SqlState=42601, NativeError=7, MessageText=ERROR; syntax error at ,;
 
> Playing around some time with ENCODING=WIN1252 instead of UTF-8 and trying the UNICODE odbc driver instead of the ANSI driver gives the following results:

> With the UNICODE driver the message does not occur, but the data returned is completely corrupted.

> With ENCODING=WIN1252 the message is slightly different:
> SQLRetcode=-1
> SqlState=42601, NativeError=7, MessageText=ERROR; syntax error at ,;
 
> What's wrong here ?

No idea, but the first thing I'd try is looking into the server's log to
see what it thought the received query was.  Anything that generates an
error would be logged by default.

			regards, tom lane

In response to

pgsql-odbc by date

Next:From: Werner KuhnleDate: 2010-09-03 14:52:26
Subject: Re-2: Problem with simple SELECT over ODBC
Previous:From: Werner KuhnleDate: 2010-09-03 09:00:45
Subject: Problem with simple SELECT over ODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group