We recently upgraded from a very old version of ODBC client 8.x to the current version 11.x. Development is in Visual C++ 6.0, this is a circa 1998 version.
The issue that we are having is that the ODBC driver is returning SQL_SUCCESS_WITH_INFO, yet is not actually updating the records. We are only updating one of the fields of the record (one of the columns of the table row).
The really weird aspect is that the problem can be replicated by changing the value of one of the numeric fields of the record (columns of the table row) to a specific value. This other field is not the field that we are updating.
When we change the numeric field to 119.60 the ODBC driver returns SQL_SUCCESS_WITH_INFO and fails to update the record. When we change the numeric field to 139.54, the ODBC driver returns SQL_SUCCESS and correctly updates the record.
Does anyone have any ideas how we can solve (or work-around) this problem? Is this an ODBC driver bug?