I am using a VB program to, among other things, display and edit fields on an AS400 database. I am using IBM's AS400 OLE DB Provider and ADO 2.8.
All the fields update fine except for one field for in which Comment memos are stored. On the AS400, this field is of type VARLEN, a variable length field. When I try to update a change made to this field, I get the following error:
Run-time error '-2147467259 (80004005)':
CWBZZ5014 Value of parameter DMMEMO could not be converted to the host data type.
My question is, does anyone know how to deal with updating variable length fields using VB? Is there some special code that can do this? I have not been able to find any information on this. I tried installing the latest Service Packs for IBM iSeries Access, but this did not fix my problem.