Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SELECTBLOB fails for large Blobs fields

31 views
Skip to first unread message

Nutshell

unread,
Mar 26, 2006, 3:17:25 PM3/26/06
to
Hi all!

I have a SELECTBLOB statement that works fine for small (~941790 bytes)
Blobs but fails for larger ones. I can't get any error description from the
transaction object except SQLCode (-1) and SQLDBCode 2. I'm using OLE-DB
with MS SQL Server 2000 and
PB 10.0.1 (6064).

I've tried to set the Autocommit to true before calling SELECTBLOB, however
the call fails anyhow.

Any tip is welcome

TIA;


Maggie

unread,
Mar 26, 2006, 9:26:51 PM3/26/06
to
Hi TIA,

For the problem you mentioned, please open pbodb100.ini (under
shared\powerbuilder) , go to [MS SQL Server] section, change the setting of
PBMaxBlobSize='32767' to PBMaxBlobSize= 'a value greater than your blob
size' or just comment out this line Rem PBMaxBlobSize='32767' to indicate
that blob size is not limited. After the change, please restart PB and try
to run you app again.

Regards,
Maggie

"Nutshell" <nos...@nospam.com> wrote in message
news:4426e6c2$1@forums-2-dub...

Nutshell

unread,
Mar 31, 2006, 6:48:42 AM3/31/06
to
Ok, Right! I love You Maggie ;-)


"Maggie" <Magg...@sybase.com> skrev i meddelandet
news:44273d56@forums-2-dub...

0 new messages