ASP, Firebird & Blob issues

Hello:

I need some help with ADO types. I use an stored procedure to insert records in a table. One of columns needed is a Blob type (subtype Text). In adition I use ADODB.command configured as I show:

...
oProcedure.Parameters.Append oProcedure.CreateParameter("Description", adLongVarChar, adParamInput, 1234567, description)
...

But it doesn't work well. After call, the table shows something like binary data.

I'd tried to use other ADO types like adVarChar, adVarWChar, adLongVarBinary,... with same result or type errors.

Could anyone help me? Please I'm desperate

thks for your help

Did you try adLongText, it might sound stupid but I didn't see it in your list.
Also seems correct for a blob, are you shure that text is not implicitly converted into blob?

adLongText seems not exist in ADO data types




The problem is that the text isn't correctly stored on database. When I use database gui (IB Expert) to prove the procedure the information stored in blob field is readable.

Yesterday I tried to use .Appendchunk method to configure Parameter whith same result.


...
if type = adLongVarChar then
oProcedure.Parameters.Append oProcedure.CreateParameter(i, type, adParamInput, len(data))
oProcedure.Parameters(i).AppendChunk(data)
else
oProcedure.Parameters.Append oProcedure.CreateParameter(clave, type, adParamInput, len(data), data)
end if
next
...

Well, see http://www.samspublishing.com/conte..._0789729520.pdf

Yes I know this document. The use of appendchunk is extracted from that examples. But I've the same problem.

Maybe I've a problem with the Firebird ODBC driver.