Export (0) Print
Expand All
18 out of 50 rated this helpful - Rate this topic

Appendix A: ODBC Error Codes

This topic discusses SQLSTATE values for ODBC 3.x. For more information on ODBC 3.x SQLSTATE values, see SQLSTATE Mappings.

SQLGetDiagRec or SQLGetDiagField returns SQLSTATE values as defined by Open Group Data Management: Structured Query Language (SQL), Version 2 (March 1995). SQLSTATE values are strings that contain five characters. The following table lists SQLSTATE values that a driver can return for SQLGetDiagRec.

The character string value returned for an SQLSTATE consists of a two-character class value followed by a three-character subclass 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 value of SQL_ERROR. The class "IM" is specific to warnings and errors that derive from the implementation of ODBC itself. The subclass value "000" in any class indicates that there is no subclass for that SQLSTATE. The assignment of class and subclass values is defined by SQL-92.

Note Note

Although successful execution of a function is normally indicated by a return value of SQL_SUCCESS, the SQLSTATE 00000 also indicates success.

SQLSTATE

Error

Can be returned from

01000

General warning

All ODBC functions except:

SQLError

SQLGetDiagField

SQLGetDiagRec

01001

Cursor operation conflict

SQLExecDirect

SQLExecute

SQLParamData

SQLSetPos

01002

Disconnect error

SQLDisconnect

01003

NULL value eliminated in set function

SQLExecDirect

SQLExecute

SQLParamData

01004

String data, right-truncated

SQLBrowseConnect

SQLBulkOperations

SQLColAttribute

SQLDataSources

SQLDescribeCol

SQLDriverConnect

SQLDrivers

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLGetConnectAttr

SQLGetCursorName

SQLGetData

SQLGetDescField

SQLGetDescRec

SQLGetEnvAttr

SQLGetInfo

SQLGetStmtAttr

SQLNative

Sql SQLParamData

SQLPutData

SQLSetCursorName

01006

Privilege not revoked

SQLExecDirect

SQLExecute

SQLParamData

01007

Privilege not granted

SQLExecDirect

SQLExecute

SQLParamData

01S00

Invalid connection string attribute

SQLBrowseConnect

SQLDriverConnec

01S01

Error in row

SQLBulkOperations

SQLExtendedFetch

SQLSetPos

01S02

Option value changed

SQLBrowseConnect

SQLConnect

SQLDriverConnect

SQLExecDirect

SQLExecute

SQLParamData

SQLPrepare

SQLSetConnectAttr

SQLSetDescField

SQLSetEnvAttr

SQLSetStmtAttr

01S06

Attempt to fetch before the result set returned the first rowset

SQLExtendedFetch

SQLFetchScroll

01S07

Fractional truncation

SQLBulkOperations

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLGetData

SQLParamData

SQLSetPos

01S08

Error saving File DSN

SQLDriverConnect

01S09

Invalid keyword

SQLDriverConnect

07001

Wrong number of parameters

SQLExecDirect

SQLExecute

07002

COUNT field incorrect

SQLExecDirect

SQLExecute

SQLParamData

07005

Prepared statement not a cursor-specification

SQLColAttribute

SQLDescribeCol

07006

Restricted data type attribute violation

SQLBindCol

SQLBindParameter

SQLBulkOperations

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLGetData

SQLParamData

SQLPutData

SQLSetPos

07009

Invalid descriptor index

SQLBindCol

SQLBindParameter

SQLBulkOperations

SQLColAttribute

SQLDescribeCol

SQLDescribeParam

SQLFetch

SQLFetchScroll

SQLGetData

SQLGetDescField

SQLGetDescRec

SQLParamData

SQLSetDescField

SQLSetDescRecSQLSetPos

07S01

Invalid use of default parameter

SQLExecDirect

SQLExecute

SQLParamData

SQLPutData

08001

Client unable to establish connection

SQLBrowseConnect

SQLConnect

SQLDriverConnect

08002

Connection name in use

SQLBrowseConnect

SQLConnect

SQLDriverConnect

SQLSetConnectAttr

08003

Connection not open

SQLAllocHandle

SQLDisconnect

SQLEndTran

SQLGetConnectAttr

SQLGetInfo

SQLNativeSql

SQLSetConnectAttr

08004

Server rejected the connection

SQLBrowseConnect

SQLConnect

SQLDriverConnect

08007

Connection failure during transaction

SQLEndTran

08S01

Communication link failure

SQLBrowseConnect

SQLColumnPrivileges

SQLColumns

SQLConnect

SQLCopyDesc

SQLDescribeCol

SQLDescribeParam

SQLDriverConnect

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLForeignKeys

SQLGetConnectAttr

SQLGetData

SQLGetDescField

SQLGetDescRec

SQLGetFunctions

SQLGetInfo

SQLGetTypeInfo

SQLMoreResults

SQLNativeSql

SQLNumParams

SQLNumResultCols

SQLParamData

SQLPrepare

SQLPrimaryKeys

SQLProcedureColumns

SQLProcedures

SQLPutData

SQLSetConnectAttr

SQLSetDescField

SQLSetDescRec

SQLSetEnvAttr

SQLSetStmtAttr

SQLSpecialColumns

SQLStatistics

SQLTablePrivileges

SQLTables

21S01

Insert value list does not match column list

SQLExecDirect

SQLPrepare

21S02

Degree of derived table does not match column list

SQLBulkOperations

SQLExecDirect

SQLExecute

SQLParamData

SQLPrepare

SQLSetPos

22001

String data, right-truncated

SQLBulkOperations

SQLExecDirect

SQLExecute

SQLFetch

SQLFetchScroll

SQLParamData

SQLPutData

SQLSetDescField

SQLSetPos

22002

Indicator variable required but not supplied

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLGetData

SQLParamData

22003

Numeric value out of range

SQLBulkOperations

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLGetData

SQLGetInfo

SQLParamData

SQLPutData

SQLSetPos

22007

Invalid datetime format

SQLBulkOperations

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLGetData

SQLParamData

SQLPutData

SQLSetPos

22008

Datetime field overflow

SQLBulkOperations

SQLExecDirect

QLParamData

SQLPutData

22012

Division by zero

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLGetData

SQLPutData

22015

Interval field overflow

SQLBulkOperations

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLGetData

SQLParamData

SQLPutData

SQLSetPos

22018

Invalid character value for cast specification

SQLBulkOperations

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLGetData

SQLParamData

SQLPutData

SQLSetPos

22019

Invalid escape character

SQLExecDirect

SQLExecute

SQLPrepare

22025

Invalid escape sequence

SQLExecDirect

SQLExecute

SQLPrepare

22026

String data, length mismatch

SQLParamData

23000

Integrity constraint violation

SQLBulkOperations

SQLExecDirect

SQLExecute

SQLParamData

SQLSetPos

24000

Invalid cursor state

SQLBulkOperations

SQLCloseCursor

SQLColumnPrivileges

SQLColumns

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLForeignKeys

SQLGetData

SQLGetStmtAttr

SQLGetTypeInfo

SQLNativeSql

SQLPrepare

SQLPrimaryKeys

SQLProcedureColumns

SQLProcedures

SQLSetConnectAttr

SQLSetCursorName

SQLSetPos

SQLSetStmtAttr

SQLSpecialColumns

SQLStatistics

SQLTablePrivileges

SQLTables

25000

Invalid transaction state

SQLDisconnect

25S01

Transaction state

SQLEndTran

25S02

Transaction is still active

SQLEndTran

25S03

Transaction is rolled back

SQLEndTran

28000

Invalid authorization specification

SQLBrowseConnect

SQLConnect

SQLDriverConnect

34000

Invalid cursor name

SQLExecDirect

SQLPrepare

SQLSetCursorName

3C000

Duplicate cursor name

SQLSetCursorName

3D000

Invalid catalog name

SQLExecDirect

SQLPrepare

SQLSetConnectAttr

3F000

Invalid schema name

SQLExecDirect

SQLPrepare

40001

Serialization failure

SQLBulkOperations

SQLColumnPrivileges

SQLColumns

SQLEndTran

SQLExecDirect

SQLExecute

SQLFetch

SQLFetchScroll

SQLForeignKeys

SQLGetTypeInfo

SQLMoreResults

SQLParamData

SQLPrimaryKeys

SQLProcedureColumns

SQLProcedures

SQLSetPos

SQLSpecialColumns

SQLStatistics

SQLTablePrivileges

SQLTables

40002

Integrity constraint violation

SQLEndTran

40003

Statement completion unknown

SQLBulkOperations

SQLColumnPrivileges

SQLColumns

SQLExecDirect

SQLExecute

SQLFetch

SQLFetchScroll

SQLForeignKeys

SQLGetTypeInfo

SQLMoreResults

SQLPrimaryKeys

SQLProcedureColumns

SQLProcedures

SQLParamData

SQLSetPos

SQLSpecialColumns

SQLStatistics

SQLTablePrivileges

SQLTables

42000

Syntax error or access violation

SQLBulkOperations

SQLExecDirect

SQLExecute

SQLParamData

SQLPrepare

SQLSetPos

42S01

Base table or view already exists

SQLExecDirect

SQLPrepare

42S02

Base table or view not found

SQLExecDirect

SQLPrepare

42S11

Index already exists

SQLExecDirect

SQLPrepare

42S12

Index not found

SQLExecDirect

SQLPrepare

42S21

Column already exists

SQLExecDirect

SQLPrepare

42S22

Column not found

SQLExecDirect

SQLPrepare

44000

WITH CHECK OPTION violation

SQLBulkOperations

SQLExecDirect

SQLExecute

SQLParamData

SQLSetPos

HY000

General error

All ODBC functions except:

SQLError

SQLGetDiagField

SQLGetDiagRec

HY001

Memory allocation error

All ODBC functions except:

SQLError

SQLGetDiagField

SQLGetDiagRec

HY003

Invalid application buffer type

SQLBindCol

SQLBindParameter

SQLGetData

HY004

Invalid SQL data type

SQLBindParameter

SQLGetTypeInfo

HY007

Associated statement is not prepared

SQLCopyDesc

SQLGetDescField

SQLGetDescRec

HY008

Operation canceled

All ODBC functions that can be processed asynchronously:

SQLBrowseConnect

SQLBulkOperations

SQLColAttribute

SQLColumnPrivileges

SQLColumns

SQLConnect

SQLDescribeCol

SQLDescribeParam

SQLDisconnect

SQLDriverConnect

SQLEndTran

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLForeignKeys

SQLGetData

SQLGetTypeInfo

SQLMoreResults

SQLNumParams

SQLNumResultCols

SQLParamData

SQLPrepare

SQLPrimaryKeys

SQLProcedureColumns

SQLProcedures

SQLPutData

SQLSetConnectAttr

SQLSetPos

SQLSpecialColumns

SQLStatistics

SQLTablePrivileges

SQLTables

HY009

Invalid use of null pointer

SQLAllocHandle

SQLBindParameter

SQLBulkOperations

SQLColumnPrivileges

SQLColumns

SQLExecDirect

SQLForeignKeys

SQLGetCursorName

SQLGetData

SQLGetFunctions

SQLNativeSql

SQLPrepare

SQLPrimaryKeys

SQLProcedureColumns

SQLProcedures

SQLPutData

SQLSetConnectAttr

SQLSetCursorName

SQLSetEnvAttr

SQLSetStmtAttr

SQLSpecialColumns

SQLStatistics

SQLTablePrivileges

SQLTables

HY010

Function sequence error

SQLAllocHandle

SQLBindCol

SQLBindParameter

SQLBulkOperations

SQLCloseCursor

SQLColAttribute

SQLColumnPrivileges

SQLColumns

SQLCopyDesc

SQLDescribeCol

SQLDescribeParam

SQLDisconnect

SQLEndTran

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLForeignKeys

SQLFreeHandle

SQLFreeStmt

SQLGetConnectAttr

SQLGetCursorName

SQLGetData

SQLGetDescField

SQLGetDescRec

SQLGetFunctions

SQLGetStmtAttr

SQLGetTypeInfo

SQLMoreResults

SQLNumParams

SQLNumResultCols

SQLParamData

SQLPrepare

SQLPrimaryKeys

SQLProcedureColumns

SQLProcedures

SQLPutData

SQLRowCount

SQLSetConnectAttr

SQLSetCursorName

SQLSetDescField

SQLSetEnvAttr

SQLSetDescRec

SQLSetPos

SQLSetStmtAttr

SQLSpecialColumns

SQLStatistics

SQLTablePrivileges

SQLTables

HY011

Attribute cannot be set now

SQLBulkOperations

SQLParamData

QLSetPos

SQLSetStmtAttr

HY012

Invalid transaction operation code

SQLEndTran

HY013

Memory management error

All ODBC functions except:

SQLGetDiagField

SQLGetDiagRec

HY014

Limit on the number of handles exceeded

SQLAllocHandle

HY015

No cursor name available

SQLGetCursorName

HY016

Cannot modify an implementation row descriptor

SQLCopyDesc

SQLSetDescField

SQLSetDescRec

HY017

Invalid use of an automatically allocated descriptor handle

SQLFreeHandle

SQLSetStmtAttr

HY018

Server declined cancel request

SQLCancel

HY019

Non-character and non-binary data sent in pieces

SQLPutData

HY020

Attempt to concatenate a null value

SQLPutData

HY021

Inconsistent descriptor information

SQLBindParameter

SQLCopyDesc

SQLGetDescField

SQLSetDescField

SQLSetDescRec

HY024

Invalid attribute value

SQLSetConnectAttr

SQLSetEnvAttr

SQLSetStmtAttr

HY090

Invalid string or buffer length

SQLBindCol

SQLBindParameter

SQLBrowseConnect

SQLBulkOperations

SQLColAttribute

SQLColumnPrivileges

SQLColumns

SQLConnect

SQLDataSources

SQLDescribeCol

SQLDriverConnect

SQLDrivers

SQLExecDirect

SQLExecute

SQLFetch

SQLFetchScroll

SQLForeignKeys

SQLGetConnectAttr

SQLGetCursorName

SQLGetData

SQLGetDescField

SQLGetInfo

SQLGetStmtAttr

SQLNativeSql

SQLParamData

SQLPrepare

SQLPrimaryKeys

SQLProcedureColumns

SQLProcedures

SQLPutData

SQLSetConnectAttr

SQLSetCursorName

SQLSetDescField

SQLSetDescRec

SQLSetEnvAttr

SQLSetStmtAttr

SQLSetPos

SQLSpecialColumns

SQLStatistics

SQLTablePrivileges

SQLTables

HY091

Invalid descriptor field identifier

SQLColAttribute

SQLGetDescField

SQLSetDescField

HY092

Invalid attribute/option identifier

SQLAllocHandle

QLBulkOperations

SQLCopyDesc

SQLDriverConnect

SQLEndTran

SQLFreeStmt

SQLGetConnectAttr

SQLGetEnvAttr

QLParamData

SQLSetConnectAttr

SQLSetDescField

SQLSetEnvAttr

SQLSetPos

SQLSetStmtAttr

HY095

Function type out of range

SQLGetFunctions

HY096

Invalid information type

SQLGetInfo

HY097

Column type out of range

SQLSpecialColumns

HY098

Scope type out of range

SQLSpecialColumns

HY099

Nullable type out of range

SQLSpecialColumns

HY100

Uniqueness option type out of range

SQLStatistics

HY101

Accuracy option type out of range

SQLStatistics

HY103

Invalid retrieval code

SQLDataSources

SQLDrivers

HY104

Invalid precision or scale value

SQLBindParameter

HY105

Invalid parameter type

SQLBindParameter

SQLExecDirect

SQLExecute

SQLParamData

SQLSetDescField

HY106

Fetch type out of range

SQLExtendedFetch

SQLFetchScroll

HY107

Row value out of range

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLSetPos

HY109

Invalid cursor position

SQLExecDirect

SQLExecute

SQLGetData

SQLGetStmtAttr

SQLNativeSql

SQLParamData

SQLSetPos

HY110

Invalid driver completion

SQLDriverConnect

HY111

Invalid bookmark value

SQLExtendedFetch

SQLFetchScroll

HYC00

Optional feature not implemented

SQLBindCol

SQLBindParameter

SQLBulkOperations

SQLColAttribute

SQLColumnPrivileges

SQLColumns

SQLDriverConnect

SQLEndTran

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLForeignKeys

SQLGetConnectAttr

SQLGetData

SQLGetEnvAttr

SQLGetInfo

SQLGetStmtAttr

SQLGetTypeInfo

SQLParamData

SQLPrepare

SQLPrimaryKeys

SQLProcedureColumns

SQLProcedures

SQLSetConnectAttr

SQLSetEnvAttr

SQLSetPos

SQLSetStmtAttr

SQLSpecialColumns

SQLStatistics

SQLTablePrivileges

SQLTables

HYT00

Timeout expired

SQLBrowseConnect

SQLBulkOperations

SQLColumnPrivileges

SQLColumns

SQLConnect

SQLDriverConnect

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLForeignKeys

SQLGetTypeInfo

SQLParamData

SQLPrepare

SQLPrimaryKeys

SQLProcedureColumns

SQLProcedures

SQLSetPos

SQLSpecialColumns

SQLStatistics

SQLTablePrivileges

SQLTables

HYT01

Connection timeout expired

All ODBC functions except:

SQLDrivers

SQLDataSources

SQLGetEnvAttr

SQLSetEnvAttr

IM001

Driver does not support this function

All ODBC functions except:

SQLAllocHandle

SQLDataSources

SQLDrivers

SQLFreeHandle

SQLGetFunctions

IM002

Data source name not found and no default driver specified

SQLBrowseConnect

SQLConnect

SQLDriverConnect

IM003

Specified driver could not be loaded

SQLBrowseConnect

SQLConnect

SQLDriverConnect

IM004

Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

SQLBrowseConnect

SQLConnect

SQLDriverConnect

IM005

Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

SQLBrowseConnect

SQLConnect

SQLDriverConnect

IM006

Driver's SQLSetConnectAttr failed

SQLBrowseConnect

SQLConnect

SQLDriverConnect

IM007

No data source or driver specified; dialog prohibited

SQLDriverConnect

IM008

Dialog failed

SQLDriverConnect

IM009

Unable to load translation DLL

SQLBrowseConnect

SQLConnect

SQLDriverConnect

SQLSetConnectAttr

IM010

Data source name too long

SQLBrowseConnect

SQLConnect

SQLDriverConnect

IM011

Driver name too long

SQLBrowseConnect

SQLDriverConnect

IM012

DRIVER keyword syntax error

SQLBrowseConnect

SQLDriverConnect

IM013

Trace file error

All ODBC functions.

IM014

Invalid name of File DSN

SQLDriverConnect

IM015

Corrupt file data source

SQLDriverConnect

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.