Re: ODBC + BYTEA - Mailing list pgsql-odbc

From Alex Goncharov
Subject Re: ODBC + BYTEA
Date
Msg-id E1MNsVy-0003wW-Tn@daland.home
Whole thread Raw
In response to ODBC + BYTEA  (Michael Knigge <Michael.Knigge@SET-Software.de>)
List pgsql-odbc
,--- You/Michael (Mon, 06 Jul 2009 19:28:11 +0200) ----*
| Now.... when I execute this SQL via ODBC, I get a
|
| 42704 (7:1260) ERROR: type "lo" does not exist;Error while executing the

| I've googled around a bit and if I got things right "lo" is somewhat an
| old-style datatype for binary stuff and nowadays "bytea" should be used.

Try to set

  ByteaAsLongVarBinary = 1

in your ODBC driver configuration. On Windows use Admin Tools / Data
Sources (ODBC) -> PostgreSQL35* -> Datasources -> Page 2 -> play with
the check box "bytea as LO".

-- Alex -- alex-goncharov@comcast.net --

pgsql-odbc by date:

Previous
From: Michael Knigge
Date:
Subject: ODBC + BYTEA
Next
From: "Kulik, Scott"
Date:
Subject: Re: help compiling psqldobc-08.03.0400