Good news everyone, I managed to work with jpg pictures stored in an image field on sql server, and succesfully previewed the blob field in crystal 9.0 without using image conversion code or any other app. The thing is you have to load the pic in the image field not through T-SQL but through a...
B2bnettools, you the man if it works... I'm under pressure to finish a report with blob fields included and this might get me going. Any sample code for the conversion to jpg that you mentioned? That would definitely save some more time, as it seems that converting the image simply by saving it...
I have the same problem with blob fields in crystal 9. I am trying to preview a blob field from sql server 2000 (image data type) and cannot get it work. I've tried to insert all types of formats for pictures in the binary field (bmp,tiff,gif) and of all sizes (over and under 7kb - remember that...
To get the image in the SQL image (large binary) field, write the following in query analyzer (anything between - - is a remark, anything between <> should be replaced with actual table,field etc names):
-First, create a record with a dummy value for the binary field. The value shown here is a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.