ADo - Append chunk - Passing a blob greater than 64K as a stored procedure parameter
Posted on 2004-10-20
I'm having problems passing a Blob greater than 64k. If I add a single chunk less than 64k there is no problem .. if I add multiple chunks I get an error on the cmd.Execute line. The error is:
"Application uses a value of the wrong type for the current operation." I've seen this error before when you pass a chunk greater than that specified. If I try pass a chunk greater than 64k I get an errrr due to data truncation.
I'm currently breaking my blob (byte array) into chunks of 60k.
Here's a code extract:
MaxChunkSize = 60000
Set prmData = cmd.CreateParameter("ReportFileData", adLongVarBinary, adParamInput, MaxChunkSize + 1)
prmData.Attributes = adFldLong
For each Chunk in colChunks
Any ideas how to append this large blob ?