| Lists: | pgsql-odbc |
|---|
| From: | mengel(at)notes(dot)cc(dot)sunysb(dot)edu |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | ByteA as LO parameter |
| Date: | 2007-03-02 16:48:31 |
| Message-ID: | OFFB1CCEA4.07C103F8-ON85257292.005C0AAF-85257292.005C5686@notes.cc.sunysb.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
I've been trying to set the Bytea as LO parameter programmatically via VB.
I can't seem to get it right. Has anyone done this? What's the name of
the parameter? I've tried ByteaAsLongVarBinary, but that was purely a
guess. I found it in the registry. Needless to say it didn't work. Any
thoughts?
Thanks,
Matthew Engel
Senior Programmer/Analyst
State University of New York at Stony Brook
mengel(at)notes(dot)cc(dot)sunysb(dot)edu
| From: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| To: | mengel(at)notes(dot)cc(dot)sunysb(dot)edu |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: ByteA as LO parameter |
| Date: | 2007-03-02 22:51:29 |
| Message-ID: | 45E8AA71.1030509@tpf.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
mengel(at)notes(dot)cc(dot)sunysb(dot)edu wrote:
> I've been trying to set the Bytea as LO parameter programmatically
via VB. I can't seem to get it right. Has anyone done this?
> What's the name of the parameter? I've tried ByteaAsLongVarBinary,
but that was purely a guess. I found it in the registry. Needless to
say it didn't work. Any thoughts?
Please add ByteaAsLongVarBinary=1 to your connection string.
regards,
Hiroshi Inoue