Postgres Pro
Downloads
Home   >   mailing lists

Thread: ODBC escape convert error

ODBC escape convert error

From
"Richard Broersma"
Date:
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?

--
Regards,
Richard Broersma Jr.

Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
Attachment

Re: ODBC escape convert error

From
Hiroshi Inoue
Date:
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

Re: ODBC escape convert error

From
"Richard Broersma"
Date:
On Wed, Jun 11, 2008 at 11:49 AM, Hiroshi Inoue <inoue@tpf.co.jp> wrote:

> You may have to replace '{' (ODBC escape) by '(' in the line.
>
>      .CommandText = .CommandText & "      WHERE { T.instrumentcode,
> T.instrumentsuff, T.area, T.loopnbr ) IS NULL;

Correct again!  Everything works perfectly now!


--
Regards,
Richard Broersma Jr.

Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug