Extract image from blob in SQL Server table.

OK, a strange one. Does anyone know the format that Navision holds a bitmap within a BLOB field , or more specifically the format held in the underlying SQL server binary field relating to the BLOB object? What we are trying to do is create a .net program that extracts some information directly from a SQL Server Navision database and need to extract an image held in a BLOB/BINARY field. Any pointers extremely welcome.

Take a look at the properties of your BLOB field in the table designer. By default the Compressed property is , which means the value is zipped and not usable externally. Change this property to No and the value will be the binary of a normal bitmap format (provided that is whats stored there) which you can extract and display externally.

Yep, missed that property. Images sucessfully retrieved. Many thanks for your help.