I'm having a problem within my VB6 application. I have to update a BLOB column in a DB2 table and face a very curious problem. I have tried it with 2 different tables (Create table a (id decimal(10), data blob); Create table b (id decimal(10), data long varchar for bit data), 2 different conection strings and with the option LONGDATACOMPAT=1 in the DB2cli.ini file.
When I'm using the IBMDADB2 Provider or the ODBC conection with the LONGDATACOMPAT option I'm getting the error [DB2/NT] SQL0204N "TEST.a" is an undefined name. SQLSTATE=42704. This error occurs at the 'call rs.update' statement. The 'rs.open' statement works correct. Very strange errormessage. When I remove the LONGDATACOMPAT option I get the error [IBM][CLI Driver] CLI0102E Invalid conversion. SQLSTATE=07006.
Private Con As New ADODB.Connection