INFO: Appendix A ODBC Error Codes

MORE INFORMATION

Appendix A: Open Database Connectivity (ODBC) Error Codes

SQLError returns SQLState values as defined by the X/Open and SQL Access Group SQL CAE draft specification (1991). SQLState values are strings that contain five characters. The downloadable file that is included in this article contains a list of SQLState values that a driver can return for SQLError.

The following file is available for download from the Microsoft Download Center:
Release Date: August 27, 2002

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

The character string value that is returned for a SQLSTATE is made up of a two-character class value followed by a three-character derived class value. A class value of '01' indicates a warning and is accompanied by a return code of SQL_SUCCESS_WITH_INFO. Class values other than '01', except for the class 'IM', indicate an error and are accompanied by a return code of SQL_ERROR. The class 'IM' is specific to warnings and errors that derive from the implementation of ODBC itself. The derived class value '000' in any class is for implementation-defined conditions in the specified class. The assignment of class and derived class values is defined by ANSI SQL2.