There a several types of errors that can be reported from the Web Data Administrator.
These errors occur when the Web Data Administrator attempts to assert some condition that fails. Some examples are:
- Failure to enter data in a field that is required, like omitting the name when creating a new database
- Failure to enter the correct data type in a particular field, like setting the length of a varchar column to a non-integer number
- Attempting to access an object that no longer exists, like a table that has been deleted from outside the Web Data Administrator tool.
These errors are reported by the SQL-DMO library when the Web Data Administrator attempts to perform an operation on the connected database server for which it has given invalid parameters or has insufficient permission to complete. For example:
There was an error saving the stored procedure.
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near 'select'.
Unhandled errors are unanticipated by the Web Data Administrator, and are displayed as stack trace information indicating the exception and location in source code where the error occured.