PRB: Constraints, Primary Keys, and Defaults Using Recordset DTC

SYMPTOMS

When you update or add records, using a Recordset Design-time control (DTC) with the Scripting Platform set to "Server (ASP)", it fails to validate database constraints, primary keys, or insert default values. No error messages display if the database constraints or primary keys are invalid. Additionally, default values are not applied if fields are left blank.