Base64 Image retrival / display (1 Viewer)

Minty

AWF VIP
Local time
Today, 21:18
Joined
Jul 26, 2013
Messages
10,368
I want to display / print a image stored in linked SQL Server database. The image in question is a signature captured from a html web based sign off form.

The server data is a string (varchar(Max)) of the format
Code:
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAhAAAAFKCAYAAABM/WaFAAAgAElEQVR4Xu3dCbiV0x7H8b9ZS....

Using Access 2010 I thought I could simply display this in an image control, but apparently not.

Having done some google research , I've looked at stripping the initial data:image/png;base64, and converting the string to hex for display without success. Image manipulation is certainly not a strong point of mine, so am I missing something glaringly obvious in trying to put this on a a report or form? I can upload some samples if anyone think it would help.
 

Minty

AWF VIP
Local time
Today, 21:18
Joined
Jul 26, 2013
Messages
10,368
I've played around with this for about a day now and drawn a blank (literally ;) ). I think it may be an issue with Access not liking the png format.

In SSRS I can display it by stripping the initial text and using and image box with
Code:
=System.Convert.FromBase64String(Fields!Image1.Value)
as the field property.

I'll persevere and report back if I crack it, but looks like I'm going to be refreshing my SSRS skills some time soon...
 

Users who are viewing this thread

Top Bottom