| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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 --
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kulik, Scott | 2009-07-09 19:07:07 | Re: help compiling psqldobc-08.03.0400 |
| Previous Message | Michael Knigge | 2009-07-06 17:28:11 | ODBC + BYTEA |