Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
shahamel
Creator
Creator

BLOB SUCCESFULLY INTO QV (SQL)

Dear users,
For those who are having problems with a blob in your database. This is my solution.
I have a SQL Database with a table which contains an employee id and a picture. This picture has the datatype image. An image is another datatype. For example you have, integer, string, etc. Image is also a datatype.
What is did is; i made connection with my database
ODBC
CONNECT32 TO [SUDBPROD SQL2008];

Then i wrote this statement. You can change the database name and the fields to make it work for yourself.
INFO SELECT EMPLID, "EMPLOYEE_PHOTO" FROM "Synaxion LVS".dbo."SDC_PSCS_EMPL_PHOTO";
The main thing is the document i added with this discussion. When you search for 'blob' in that document you get information about blob when loading information from a database.
I hope this is useful for this community.
Gr. Sandeep
0 Replies