ByteA as LO parameter

This is a multipart message in MIME format.
--=_alternative 005C568085257292_=
Content-Type: text/plain; charset="US-ASCII"

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@notes.cc.sunysb.edu
--=_alternative 005C568085257292_=
Content-Type: text/html; charset="US-ASCII"



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@notes.cc.sunysb.edu
--=_alternative 005C568085257292_=--

Re: ByteA as LO parameter

mengel@notes.cc.sunysb.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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend