Long Binary Data to Image

Hi

Can anybody offer any assistance as to how I convert long binary data into a bitmap file

thanks

Is the long binary data a bitmap image?
If not then you're struggling. ;-)

If you mean you have a bitmap stored in a long binary field then that depends on how it was inserted.
If through Access as an "OLE Object" then Stephen Lebans has his OLEtoDisk example at http://www.lebans.com/oletodisk.htm.

If by some other means then it's standard BLOB extraction you probably want.
(Example in link in sig below).

LPurvis said:

Is the long binary data a bitmap image?
If not then you're struggling. ;-)

Click to expand...

Well I thought it was but now I'm not too sure. Its all a bit complicated really. The full story is:

I have built a comms network for communicating data from PDA's over the GPRS network. The data is to be written into an AS400 back office machine. All the data connections work correctly and the information moves about as required. The problem I have is that I need to collect signatures. The signature is captured in one of two ways, bitmap or vector. As the AS400 isn't compatible with Bitmaps I was writing the data backs as a vector but was then unable to produce this back as an image (largely due to inadequate AS400 C Programing knowledge).

I have some knowledge of access and thought I would be able to pass the image back to an access database as a bitmap to a OLE Object field. When I attempted this the data came back correctly however it was displayed as "Long Binary Data". Hence the problem.

I thought one of the links you provided me with was a good place to start however I can't seem to replicate the image (perhaps due to the way the bitmap has been coded on its transmission back to the database)

I am at a bit of a loss as to how to progress now. The other option of storing the image as a vector is a possibility I am sure but alas no success with the conversion there either.

I am wondering whether it may just be better to buy some third party software to perform the conversion for me after the AS400 receives the vector string back.

I've read this post and your post regarding digital signatures stored as points along a flexible curved line. What you are doing is, in essence, trying to create a plotter driver for a window. (Or perhaps you would prefer to call it a vector manager.) VBA can probably handle short vector sets, but it would require you to actually open a child window, write it in, and save the image in .BMP format. Which means you would have to define a long list of calls and call elements in a Win32 API.

I'm guessing that you would do better to find some third-party product for this problem.

Access 2007 should be able to store blobs (binary large objects) of another way of putting images in there native format. Dbpix (a paid for solution) will also handle blobs. Unless you have no other alternative don't use bitmaps as they are so "efficient" that they bloat a file by a factor of 20KBs to up to 1000KBs.

Simon

Big_Si's actual intention can be seen in this thread.

Is that uuencoded binary?

Simon

Simon_MT said:

Is that uuencoded binary?

Simon

Click to expand...

No, according to what is posted in the thread, the signature is stored in the database as a hexadecimal string.

Sorry about the confusion guys