Loading Images from SQL server 2008

[#1]

Hi Guys,

I'm following these steps in order to load images to Qlikview:.

1. Create a table to contain the image as a varbinary or image
   
   CREATE TABLE ImageAsVarBinary
   (
     ID int IDENTITY(1,1),
     ImageName varChar(50),
     varBinaryData varBinary(MAX)
   );
2. Load an image file to the table
   
   INSERT INTO ImageAsVarBinary (ImageName, varBinaryData)
   SELECT 'image1', BulkColumn FROM OPENROWSET (Bulk 'C:\Test.jpg', SINGLE_BLOB) AS varBinaryData;
3. Load the image to QVW by using an info load
   
   INFO SQL SELECT
   ImageName,
   varBinaryData
   FROM "DB_TABLE_NAME".dbo.ImageAsVarBinary;
4. Show the image in an object by setting the field value to
   
   =INFO(ImageName)
5. Set the field/object Representation to Image

But the problem is showing  binary data not image as the attached document. Can anyone help me ?

[MarcoWedel]

Maybe you could temporarily write the images to disk and bundle info load them from there?

Regards

Marco

[#3]

I use this query:

Info SQL SELECT ImageName,

varBinaryData

FROM TestQlikImage.dbo.ImageAsVarBinary;

but it's not working, it gives me the same result.

Thanks for replaying

[MarcoWedel]

Maybe this helps:

Importing user picture ressource from AD using OLE DB Provider for Microsoft Directory Services

regards

Marco