Unanswered: Need Help With ADO Recordset.addNew & OLE DB
I have no problem using the provider "IBMDADB2" for connection and inserting record using dynamic SQL; however, everytime I use the Recordset.addNew method, I kept getting the error message "com.ms.com.ComFailException: Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.". I've tried all the combination of currsor_type & lock_type, but it still does not work.
Does anyone know if the OLE DB Provider for DB2 support Recordset.addNew method, specially Recordset.appendChunk to insert BLOB. Any JAVA example or configuration tips are appreciated.