Load an image file from SQL Server DB

[#1]

hi all,

I have some images stored in an SQL Server Database, now i want to load that data into QlikView. i am using version 8.5. All the files are in binary format. please tell me how can i load image files from SQL database.

regards,

Afzal

[manishkumar75]

Hi,

I am giving you an Example :-

Suppose my Table structure is

CREATE TABLE IamgeData
(
ImageID int IDENTITY(1,1),
Imagename varChar(50),
Photo varBinary(MAX)
)

To Load the data in QlikView follow the steps:-

1. Create the Data Base Connection

2. LOAD ImageID,
Imagename,
Photo;
SELECT *
FROM QlikDemo.dbo.ImageData;

Hope it will work

- Manish

[#3]

hi manish..

I have done this but it is not showing image, instead it is showing that binary value.. now please tell what would be the problem??

thanx,

Afzal.

[manishkumar75]

Hi Afzal ,

Plz refer Page no - 312 of QlikView Reference Manual. (Actually I don't have access to Sql Server to Test the application).

- Manish

[#5]

Hi

In order to show the image you must tell QlikView to interpret as an image, for example, if you are doing this in a straight table and your image is an expression then you should change the Property "Representation" to Image.

Same sort of property exists in other objects.

Regards,

Nigel.