Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SQL vs Qlikview

Can somebody please tell me how to retrieve picture from sql database using qlikview?

7 Replies
Not applicable
Author

How is the picture saved in the database ? BLOB ?

Not applicable
Author

Check below codes

UPDATE

[SLX_Events]. [dbo]. [QV_Table_Content]



SET [qv_Image] = (SELECT *



FROM OPENROWSET(BULK 'C:\Users\user\Pictures\marula-leaf.jpg',SINGLE_BLOB) AS a)

WHERE [qv_Id]=2



Not applicable
Author

Not applicable
Author

Nah, it's not clear to me because i m using sql database. Try to give me a sample that load from sql database.

please help!

Not applicable
Author

Are you using ODBC or OLEDB ?

Not applicable
Author

i am using OLEDB

Not applicable
Author

Read page 242 in reference manual. It is possible to show BLOB images only with ODBC connection.