Need help for loading images from Odbc connection

[#1]

I want to display images from  Sql Server database.. I have used bundle load also, but the loading is not stopping only. It's loading for more than 1 hour still the loading is not finished.

Thanks in advance

[avinashelite]

First, you need to use ODBC connection instead of OLEDB. QlikView can only read the BLOB data through ODBC.

Next, you need to use the INFO + Bundle load statement to load the image data into QlikView.

then try like this

BUNDLE INFO SELECT ProductPhotoID, LargePhoto FROM DBANME.Tablename;

[#3]

i tried but still executing script is not stopping from past one hour.Data base is connecting correctly but the loading is not stopping.

[avinashelite]

can you please post the script?? will see what the issue.

[jerrysvensson]

Have you tried to load only 10 rows in debug? Could be al lot of data.

[#6]

bundle info  SELECT EmpNo,EmpPhoto

FROM ImageDB.dbo.EmpPhoto;

[#7]

i tried even debug is not working

[avinashelite]

how many records you have in the DB???

try loading top 10 , to do that use the below code at the beginning of ur load script.

first 100

If possible share your app