Re: VB (5or6) does something wierd with image data while saving to sql2000
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 27 Apr 2006 18:36:06 +0000 (UTC)
geronimi (webjc007@xxxxxxxxxxx) writes:
Vb stores an image (bitmap/jpg) in a SQL2000 image field. For some
reason it doubles the size by adding 00 for each byte. But sometimes it
doesn't add 00 (0000.0000) but 01 or 20 or ?? and also the byte that
should be transferd is changed...
So SQLImageData = Imagebyte + 00
and sometimes
SQLImageData = CHANGEDImagebyte + xx.
Some example data: (hex notation):
A1 => A1 00
03 => 03 00
-----------
91 => 18 20
83 => 92 01
8C => 52 01
Could anybody give me an explanation, because I need to know what is
happening, so I can remove te extra bytes added......
I have already a image when I remove the extra bytes, but with some
wrong data (on the place where things like 8C => 52 01 happen)....
Without seeing your code it's difficult to assist at all. And in any case
you may be better off to ask in a group for Visual Basic.
If this is a third-party app, I would suggest that you contact the vendor.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- References:
- Prev by Date: Re: Conditional Query
- Next by Date: Re: Conditional Query
- Previous by thread: VB (5or6) does something wierd with image data while saving to sql2000
- Next by thread: Re: VB (5or6) does something wierd with image data while saving to sql2000
- Index(es):
Relevant Pages
|
