Error committing transaction...

Problem

You see this error message in your application when you attempt to add or edit a record:

Error committing transaction.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: Error committing transaction.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

There are a variety of potential causes described below.

Database Schema not synchronized with Iron Speed Designer

Your database schema may have changed since building your application.  Make sure your application is synchronized with your database schema using the Databases, Scan All Tables for Changes... command.

Virtual directory properties are too restrictive

Your virtual directory properties for the application in Microsoft IIS may need “Write” permission enabled.

Gathering additional debugging information

Modify the Custom Error setting in your application’s Web.config file to disable custom error message reporting.  This will display more complete details about the error you are encountering.

See Also

Part VII:  Troubleshooting Applications

Application Will Not Run

Application Runs But No Data is Displayed

Application Error Messages