Re: ODBC + BYTEA

,--- 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 --