Basic Data View Setup Throws Error When Trying to Edit or Insert SQL Server Data on SharePoint Page

Question

Using: - MOSS 2007 - SQL Server 2005 (and Management Studio Express) - SharePoint Designer 2007 - Northwind Database (dbo.categories)

First, I am a total novice, so I am fully expecting a user error answer ;)

Here is what I did: - Opened a blank Web Part page in SharePoint Designer - Inserted a Data View - Set up a connection to the Northwind database using a user with sysadmin role - Connected to the dbo.categories table - In the data view proerties dialog, I checked the synchronize command checkbox and then checked the show edit, insert, and delete item boxes - Opened the SharePoint Page in IE, tired to insert a row and got a non-specific error message. Same happens when I try to edit a row.

Does anybody know how I can troubleshoot this?