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

Re: ODBC + BYTEA

From: Alex Goncharov <alex-goncharov(at)comcast(dot)net>
To: Michael Knigge <Michael(dot)Knigge(at)SET-Software(dot)de>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC + BYTEA
Date: 2009-07-06 18:02:06
Message-ID: E1MNsVy-0003wW-Tn@daland.home (view raw or flat)
Thread:
Lists: 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(at)comcast(dot)net --

In response to

pgsql-odbc by date

Next:From: Kulik, ScottDate: 2009-07-09 19:07:07
Subject: Re: help compiling psqldobc-08.03.0400
Previous:From: Michael KniggeDate: 2009-07-06 17:28:11
Subject: ODBC + BYTEA

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