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

Re: ODBC escape convert error

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC escape convert error
Date: 2008-06-11 18:49:21
Message-ID: 48501E31.5030107@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
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

In response to

Responses

pgsql-odbc by date

Next:From: Richard BroersmaDate: 2008-06-11 19:07:31
Subject: Re: [ODBC] what gives: SELECT INVALID SELECT STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE
Previous:From: Fred ParkinsonDate: 2008-06-11 18:37:49
Subject: Access query as executed by postgres

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