topic Re: Need help for loading images from Odbc connection in QlikView

Need help for loading images from Odbc connection

Wed, 04 Feb 2015 07:56:56 GMT

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

Re: Need help for loading images from Odbc connection

avinashelite — Wed, 04 Feb 2015 08:25:30 GMT

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;

Re: Need help for loading images from Odbc connection

Wed, 04 Feb 2015 09:18:44 GMT

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

Re: Need help for loading images from Odbc connection

avinashelite — Wed, 04 Feb 2015 09:36:46 GMT

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

Re: Need help for loading images from Odbc connection

jerrysvensson — Wed, 04 Feb 2015 09:36:51 GMT

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

Re: Need help for loading images from Odbc connection

Wed, 04 Feb 2015 09:51:59 GMT

bundle info SELECT EmpNo,EmpPhoto

FROM ImageDB.dbo.EmpPhoto;

Re: Need help for loading images from Odbc connection

Wed, 04 Feb 2015 09:52:58 GMT

i tried even debug is not working

Re: Need help for loading images from Odbc connection

avinashelite — Wed, 04 Feb 2015 10:09:45 GMT

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