Kim,
Did you ever get this to work. And - if so How so?
Terry


>Dear all,
>
>I would like to know how to return binary data into a string variable from a image datatype of SQL via ADO GetChunk. My problem is that GetChunk returning the data as HEX and store it in an array. Any suggestions.
>
>Local lcChunk,lnChunkSize, laChunk
>
>
>odata=createobject("adodb.connection")
>
>
>** Good connection
>oData.Open("provider=sqloledb;trusted_connection=yes; ;
>persist security info=False;user id=sa;data source=sqlserver; ;
>initial catalog=northwind;network library=dbmssocn;packet size=32767")
>**initial catalog=northwind;network library=dbmssocn")
>
>oRs=createobject("adodb.recordset")
>
>
>oRs.open("select * from employees ",oData,,,)
>laChunk = Space(0)
>
>
>laChunk = oRs.fields("photos").getchunk(10000)
>
>? lachunk
>disp memo like lachunk
>
>
>
>
>oRs.Close
>oData.Close
>
>
>Release all
>
>Return
>
>
>Regards,
>Kueh