Extracting Images from Sybase 1

[n2ckb]

Hi All,

I am trying to extract employee pictures from a field within a Sybase table. The field is an "image" datatype and as yet I am unable to view the content. Does anyone have any code or can point me in the right direction as to how to extract the images?

Thanks

Nick

 

[madlarry]

Hi,

You will need to use the GetChunk and AppendChunk methods to get at the BLOB data (Binary Large OBject).

Have a look at the following link:

http://support.microsoft.com/default.aspx?scid=kb;en-us;153238

I'm assuming that you are using ADO to get at the data. I know these methods work with SQL Server, I'm not of any reasons why it shouldn't work with Sybase.

Hope this helps.

 

[n2ckb]

Thanks very much Madlarry! That has worked a treat!