Board index » delphi » BlobStream limited to 32768 bytes

2004-02-11 02:02:49 AM
delphi167
I have saved some images to an image column in SQL server. Using SQL
Explorer I can see that the images are correctly saved. At the size of the
memory stream they were saved via was 76,854 bytes. When I try to read the
images back I only get part o fthe image back and the size of the blob
stream is only 32768. If I use a DB image control it shows exactly thje
same incomplete image, but as I said, SQL explorer is able to display the
complete image.
Any help appreciated.
Tim
 

I don't know how do you access the SQL server. If you use SQL Links than you
have to change the parameter BLOB SIZE in BDE Administrator.
When I use OLE DB it just works without any aditional settings.
Branko
"Tim Radford" <XXXX@XXXXX.COM>writes

Thanks. Setting the BLOB SIZE does the trick. I checked the help files too
and realised that setting RequestLive also fixes it.
Tim
"Branko Starasinic" <XXXX@XXXXX.COM>writes