All of the Microsoft® SQL Server™ version 7.0 utilities use ODBC except for the isql command prompt utility. This has two effects on the way error messages are displayed by the ODBC-based utilities:
For example, isql returns the error 208 description as:
Invalid object name 'ThisObjectDoesNotExist'.
osql includes the ODBC headers in the description:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'ThisObjectDoesNotExist'.
The presence of the ODBC headers in the message does not necessarily indicate that the problem is in the ODBC components. The SQL Server ODBC driver includes these headers in messages from all components. For more information about how to determine the component raising the error, see ODBC Error Message Format.
{ CLL sp_who }
Because the error is generated by the driver, the only message part displayed by SQL Server Query Analyzer is the description:
[Microsoft][SQL Server ODBC Driver]Syntax error or access violation
isql Utility | sysmessages |
osql Utility |