Hi,
in fact this is a resent bug report. The Windows ODBC driver doesn't
detect that a reference integrity violation occured. It realizes the
fact that there was an error, but doesn't abort the transaction.
I didn't found SC_log_error (in SC_execute) being executed. IMHO it should
abort the transaction.
Regards,
Zoltan