Postgres Pro
Downloads
Home   >   mailing lists

Re: ODBC escape convert error - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: ODBC escape convert error
Date
Msg-id 48501E31.5030107@tpf.co.jp
Whole thread Raw
In response to ODBC escape convert error  ("Richard Broersma" <richard.broersma@gmail.com>)
Responses Re: ODBC escape convert error  ("Richard Broersma" <richard.broersma@gmail.com>)
List pgsql-odbc
Tree view 
Richard Broersma wrote:
> I've attached a log file with the code for a  prepared insert command.
>  However, when it is executed, I am getting the error:
>
> ODBC escape convert error.
>
> It looks like the query never makes it to the sever becuase I don't
> see any statement logged for it.  Does anyone have any ideas?

You may have to replace '{' (ODBC escape) by '(' in the line.

      .CommandText = .CommandText & "      WHERE { T.instrumentcode,
T.instrumentsuff, T.area, T.loopnbr ) IS NULL;

regards,
Hiroshi Inoue

pgsql-odbc by date:

Previous
From: "Fred Parkinson"
Date:
Subject: Access query as executed by postgres
Next
From: "Richard Broersma"
Date:
Subject: Re: ODBC escape convert error