Binary data

[jdmcclanahan]

I am trying to update an SQL Server database from VB. I have a field that is of type varbinary. If I try to update it using a stored procedure I get the following error:

Run-time error '3421';

Application uses a value of the wrong type for the current operation.

The VB variable is a byte array which I am passing in as an adVarBinary type. I have also tried using the AppendChunk method with an ADO recordset but I get the following error:

Run-time error '3219';

Operation is not allowed in this context.

There are several articles on how to update TEXT and IMAGE fields with the AppendChunk method. But, has anyone tried to update a varbinary field? I don't think it is the same as a BLOB.

Any suggestions?

Thanks.