Hi

I can't select BLOB field from an Informix database using VBScript in
an ASP-page. We used to have the merant ODBC-driver, but after
switching to the ODBC driver in IBM Informix client SDK 2.81 our code
does not work anymore. The database is Informix 9.3 on HP-UX.

Testexample:

--Create a test-table using dbaccess:
create table blobtst(id integer, img blob)


--insert an test image using dbaccess:
INSERT INTO blobtst (id, img)
VALUES (1, FILETOBLOB('spaceshuttle.jpg', 'client'))


--verify that the image is in the database using dbaccess:
select LOTOFILE(img, 'spaceout.jpg' , 'client') from blobtst where
id=1

So far so good. Everything works perfectly well.

Example ASP code run on IIS 9.6 showing the images in a web browser:

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.open **DSN**, ***USERNAME***, ***PASSWORD****
Set oRs = oConn.Execute("select img from blobtst where id = 1")
PicSize = oRs("img").ActualSize
Pic = oRs("img").GetChunk(PicSize)
Response.Buffer = TRUE
Response.AddHeader "Content-type", "image/jpeg"
Response.BinaryWrite Pic
Response.End
oConn.close



This is the error message we recive:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done.
select_blob_tst.asp, line 5

The value of PicSize is 72, but the image I used in test was 62581
bytes

Any ideas???

// Mattias Malmgren
(remove spaces)
Mattias _ at _ freefarm _ se @ yahoo . com

Just want to inform about that if the oledb driver of infomix client
sdk is used instead of the odbc driver the same code works.
//Mattias