SharePoint University

 I'm running a WSS 3.0 and SQL Server 2005 Standard. I've created an aspx
page whith a Single item Form. Data from SQL Server database tables is shown
correctly, however when I try to modify the data and save it, I get the
following error :

The data source control failed to execute the update command.

How can I troubleshoot and solve this?

Thank you!

zaurb,

I faced the same problem this week and the solution was a little bit curious: I noticed that the error occurred  when the Title value was changed within the dataview. Then I noticed that the error didn't happen if I also changed the value of another field (called "Término" - a date field meaning "End" in portuguese. with a special character).

So I excluded the column  "Término"  and create another one without the special character: Termino

Then the error didn't happen again.

Hope this can help anyone facing the same problem.