Hi

iam facing a problem while trying to get the contents from a   BLOB 

field.

The BLOB field "file" containing image/text files.

It is getting fine through query analyzer.

The connection string is working for other operations

the error occuring in "GetChunk(size)"method.

iam using informix database

Version Informix Dynamic Server -2000 for Win NT









Set conAdoDB =3D Server.CreateObject("ADODB.Connection")

conAdoDB.Open("DSN=3Dcsdb;UID=3Dinformix;PWD=3Dinformix;")

Set oRs =3D Server.CreateObject("ADODB.Recordset")

qry=3D "select file from t_qa where no=3D"&messid  'file is a BLOB field

 oRs.Open qry, conAdoDB,adOpenStatic,adLockOptimistic



If Not oRs.BOF And Not oRs.EOF Then

   

 Dim BlobSize

        BlobSize =3D oRs("file").ActualSize

        Response.Write BlobSize            ''its printing as 72

        if BlobSize>0 then

            ByteF =3D oRs("file").GetChunk(BlobSize) 'error occuring 

here

         End If

End If



The error message is like





Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)

Multiple-step OLE DB operation generated errors. Check each OLE DB 

status value, if available. No work was done.

/csdb/qna/filedownload.asp, line 375



Does anyone of you know how to

solve this

best regards

Sagar