topic Need sample of a Database includes Images in Binary Format ?!? in QlikView

Need sample of a Database includes Images in Binary Format ?!?

ivan_will — Tue, 27 Dec 2011 15:56:27 GMT

Hello all,

Need a sample of a Database that includes images in it that are stored in a binary format so I can load them and visualize in QlikView.

Now I have a databse with pics in it but stored as a NVARCHAR type and convert them in a binary but still having problems visualize them in QV. That's why need a sample of a database just to see if it will happen or I am wrong with the nvarchar to binary conversion

Thanks!

Need sample of a Database includes Images in Binary Format ?!?

Miguel_Angel_Baeyens — Tue, 27 Dec 2011 16:16:23 GMT

Hi Ivan,

You can create a MS Access database with a BLOB field where you can insert a simple BMP file. Then you will need to create a ODBC driver using C:\Windows\SysWOW64\odbcad32.exe (MS Access does not support 64 bit format) and using the Select... button you will see how to load a blob file.

Hope that helps.

Miguel

Re: Need sample of a Database includes Images in Binary Format ?!?

IAMDV — Wed, 28 Dec 2011 18:48:29 GMT

Hi Miguel,

How can I read BLOB field from SQL Server. Let's say I have my images in SQL Server and I wanted to read them in QV. Which driver do I need to use? And do you have sample script?

Many thanks in advance.

Cheers - DV