Knowledge Base |

# INFO: Appendix A ODBC Error Codes

Article ID: 110769

Article Last Modified on 8/5/2004

APPLIES TO

- Microsoft Open Database Connectivity 1.0

This article was previously published under Q110769

## SUMMARY

The downloadable file in this article contains a list of the contents of Appendix A "ODBC Error Codes" from the Microsoft Open Database Connectivity Software Development Kit (SDK) Programmer's Reference version 1.0.

## 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:

Download Odbcerr.exe now

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:

119591 How to Obtain Microsoft Support Files from Online Services

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.

Additional query words: ODBC

Keywords: kbinfo kbdownload kbref KB110769