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

[ivan_will]

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!

[Miguel_Angel_Baeyens]

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

[IAMDV]

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