SQLSTATE codes
01000 General warning
Can be returned from all ODBC functions except:
SQLGetDiagField
SQLGetDiagRec
01001 Cursor operation conflict
Can be returned from:
SQLExecDirect
SQLExecute
SQLParamData
SQLSetPos
01002 Disconnect error
Can be returned from:
SQLDisconnect
01003 NULL value eliminated in set function
Can be returned from:
SQLExecDirect
SQLExecute
SQLParamData
01004 String data, right truncated
Can be returned from:
SQLColAttribute
SQLDataSources
SQLDescribeCol
SQLDriverConnect
SQLDrivers
SQLExecDirect
SQLExecute
SQLExtendedFetch
SQLFetch
SQLFetchScroll
SQLGetConnectAttr
SQLGetCursorName
SQLGetData
SQLGetDescField
SQLGetDescRec
SQLGetEnvAttr
SQLGetInfo
SQLGetStmtAttr
SQLParamData
SQLPutData
SQLSetCursorName
01006 Privilege not revoked
Can be returned from:
SQLExecDirect
SQLExecute
SQLParamData
01007 Privilege not granted
Can be returned from:
SQLExecDirect
SQLExecute
SQLParamData
01S00 Invalid connection string attribute
Can be returned from:
SQLDriverConnect
SQLSetPos
01S01 Error in row
Can be returned from:
SQLExtendedFetch
01S02 Option value changed
Can be returned from:
SQLConnect
SQLDriverConnect
SQLExecDirect
SQLExecute
SQLParamData
SQLPrepare
SQLSetConnectAttr
SQLSetDescField
SQLSetEnvAttr
SQLSetStmtAttr
01S06 Attempt to fetch before the result set returned the first rowset
Can be returned from:
SQLExtendedFetch
SQLFetchScroll
01S07 Fractional truncation
Can be returned from:
SQLExecDirect
SQLExecute
SQLExtendedFetch
SQLFetch
SQLFetchScroll
SQLGetData
SQLParamData
SQLSetPos
SQLExecDirect
SQLExecute
SQLExtendedFetch
SQLFetch
SQLFetchScroll
SQLGetData
SQLParamData
SQLSetPos
01S08 Error saving File DSN
Can be returned from:
SQCriverConnect
01S09 Invalid keyword
Can be returned from:
SQLDriverConnect
07001 Wrong number of parameters
Can be returned from:
SQLExecDirect
SQLExecute
07002 COUNT field incorrect
Can be returned from:
SQLExecDirect
SQLExecute
SQLParamData
07005 Prepared statement not a cursor_specification
Can be returned from:
SQLColAttribute
SQLDescribeCol
07006 Restricted data type attribute violation
Can be returned from:
SQLBindCol
SQLBindParameter
SQLExecDirect
SQLExecute
SQLExtendedFetch
SQLFetch
SQLFetchScroll
SQLGetData
SQLParamData
SQLPutData
07009 Invalid descriptor index
Can be returned from:
SQLBindCol
SQLBindParameter
SQLColAttribute
SQLDescribeCol
SQLDesribeParam
SQLFetch
SQLFetchScroll
SQLGetData
SQLGetDescField
SQLParamData
SQLSetDescField
SQLSetDescRec
SQLSetPos
07S01 Invalid use of default parameter
Can be returned from:
SQLExecDirect
SQLExecute
SQLParamData
SQLPutData
08001 Client unable to establish connection
Can be returned from:
SQLConnect
SQLDriverConnect
08002 Connection name in use
Can be returned from:
SQLConnect
SQLDriverConnect
SQLSetConnectAttr
08003 Connection does not exist
Can be returned from:
SQLAllocHandle
SQLDisconnect
SQLEndTran
SQLGetConnectAttr
SQLGetInfo
SQLSetConnectAttr
08004 Server rejected the connection
Can be returned from:
SQLConnect
SQLDriverConnect
08007 Connection failure during transaction
Can be returned from:
SQLEndTran
08S01 Communication link failure
Can be returned from:
SQLColumnPrivileges
SQLColumns
SQLConnect
SQLConnect
SQLCopyDesc
SQLDescribeCol
SQLDescribeParam
SQLDriverConnect
SQLExecDirect
SQLExecute
SQLExtendedFetch
SQLFetch
SQLFetchScroll
SQLForeignKeys
SQLGetConnectAttr
SQLGetData
SQLGetDescField
SQLGetDescRec
SQLGetFunctions
SQLGetInfo
SQLGetTypeInfo
SQLMoreResults
SQLNumParams
SQLNumResultCols
SQLParamData
SQLPrepare
SQLPrimaryKeys
SQLProcedureColumns
SQLProcedures
SQLPutData
SQLSetConnectAttr
SQLSetDescField
SQLSetDescRec
SQLSetEnvAttr
SQLSetStmtAttr
SQLSpecialColumns
SQLStatistics
SQLTablePrivileges
SQLTables
22001 String data, right truncated
Can be returned from:
SQLExecDirect
SQLExecute
SQLFetch
SQLFetchScroll
SQLParamData
SQLPutData
SQLSetDescField
SQLSetPos
22002 Indicator variable required but not supplied
Can be returned from:
SQLExecDirect
SQLExecute
SQLExtendedFetch
SQLFetch
SQLFetchScroll
SQLGetData
SQLParamData
22003 Numeric value out of range
Can be returned from:
SQLExecDirect
SQLExecute
SQLExtendedFetch
SQLFetch
SQLFetchScroll
SQLGetData
SQLGetInfo
SQLParamData
SQLPutData
SQLSetPos
22007 Invalid datetime format
Can be returned from:
SQLExecDirect
SQLExecute
SQLExtendedFetch
SQLFetch
SQLFetchScroll
SQLGetData
SQLParamData
SQLPutData
SQLSetPos
22008 Datetime field overflow
Can be returned from:
SQLExecDirect
SQLExecute
SQLParamData
SQLPutData
22012 Division by zero
Can be returned from:
SQLExecDirect
SQLExecute
SQLExtendedFetch
SQLFetch
SQLFetchScroll
SQLGetData
SQLParamData
SQLPutData
22015 Interval field overflow
Can be returned from:
SQLExecDirect
SQLExecute
SQLExtendedFetch
SQLFetch
SQLFetchScroll
SQLGetData
SQLParamData
SQLPutData
SQLSetPos
22018 Invalid character value for cast specification
Can be returned from:
SQLExecDirect
SQLExecute
SQLExtendedFetch
SQLFetch
SQLFetchScroll
SQLGetData
SQLParamData
SQLPutData
SQLSetPos
22019 Invalid escape character
Can be returned from:
SQLExecDirect
SQLExecute
SQLPrepare
22025 Invalid escape sequence
Can be returned from:
SQLExecDirect
SQLExecute
SQLPrepare
22026 String data, length mismatch
Can be returned from:
SQLParamData
23000 Integrity constraint violation
Can be returned from:
SQLExecDirect
SQLExecute
SQLParamData
SQLSetPos
24000 Invalid cursor state
Can be returned from:
SQLCloseCursor
SQLColumnPrivileges
SQLColumns
SQLExecDirect
SQLExecute
SQLExtendedFetch
SQLFetch
SQLFetchScroll
SQLForeignKeys
SQLGetData
SQLGetStmtAttr
SQLGetTypeInfo
SQLPrepare
SQLPrimaryKeys
SQLProcedureColumns
SQLProcedures
SQLConnectAttr
SQLSetCursorName
SQLSetPos
SQLSpecialColumns
SQLStatistics
SQLTablePrivileges
SQLTables
25000 Invalid transaction state
Can be returned from:
SQLDisconnect
21S01 Insert value list does not match column list
Can be returned from:
SQLExecDirect SQLPrepare
21S02 Degree of derived table does not match column list
Can be returned from:
SQLExecDirect
SQLExecute
SQLParamData
SQLPrepare
SQLSetPos
25S01 Transaction state
Can be returned from:
SQLEndTran
25S02 Transaction is still active
Can be returned from:
SQLEndTran
25S03 Transaction is rolled back
Can be returned from:
SQLEndTran
28000 Invalid authorization specification
Can be returned from:
SQLConnect
SQLDriverConnect
3C000 Duplicate cursor name
Can be returned from:
SQLSetCursorName
3D000 Invalid catalog name
Can be returned from:
SQLExecDirect
SQLPrepare
SQLSetConnectAttr
3F000 Invalid schema name
Can be returned from:
SQLExecDirect
SQLPrepare
34000 Invalid cursor name
Can be returned from:
SQLExecDirect
SQLPrepare
SQLSetCursorName
40001 Serialization failure
Can be returned from:
SQLColumnPrivileges
SQLColumns
SQLEndTran
SQLExecDirect
SQLExecute
SQLFetch
SQLFetchScroll
SQLForeignKeys
SQLGetTypeInfo
SQLMoreResults
SQLParamData
SQLPrimaryKeys
SQLProcedureColumns
SQLProcedures
SQLSetPos
SQLSpecialColumns
SQLStatistics
SQLTablePrivileges
SQLTables
40002 Integrity constraint violation
Can be returned from:
SQLEndTran
40003 Statement completion unknown
Can be returned from:
SQLColumnPrivileges
SQLColumns
SQLExecDirect
SQLExecute
SQLFetch
SQLFetchScroll
SQLGetTypeInfo
SQLForeignKeys
SQLMoreResults
SQLPrimaryKeys
SQLProcedureColumns
SQLProcedures
SQLParamData
SQLSetPos
SQLSpecialColumns
SQLStatistics
SQLTables
42000 Syntax error or access violation
Can be returned from:
SQLExecDirect
SQLExecute
SQLParamData
SQLPrepare
SQLSetPos
44000 WITH CHECK OPTION violation
Can be returned from:
SQLExecDirect
SQLExecute
SQLParamData
42S01 Base table or view already exists
Can be returned from:
SQLExecDirect
SQLPrepare
42S02 Base table or view not found
Can be returned from:
SQLExecDirect
SQLPrepare
42S11 Index already exists
Can be returned from:
SQLExecDirect
SQLPrepare
42S12 Index not found
Can be returned from:
SQLExecDirect
SQLPrepare
42S21 Column already exists
Can be returned from:
SQLExecDirect
SQLPrepare
42S22 Column not found
Can be returned from:
SQLExecDirect
SQLPrepare
HY000 General Error
Can be returned from all ODBC functions except:
SQLGetDiagField
SQLGetDiagRec
HY001 Memory allocation error
Can be returned from all ODBC function except:
SQLGetDiagField
SQLGetDiagRec
HY003 Invalid application buffer type
Can be returned from:
SQLBindCol
SQLBindParameter
SQLGetData
HY004 Invalid SQL data type
Can be returned from:
SQLBindParameter
SQLGetTypeInfo
HY007 Associated statement is not prepared
Can be returned from:
SQLCopyDesc
SQLGetDescField
SQLGetDescRec
HY008 Operation canceled
Can be returned from all ODBC functions that can be processed asynchronously:
SQLColAttribute
SQLColumnPrivileges
SQLColumns
SQLDescribeCol
SQLDescribeParam
SQLExecDirect
SQLExecute
SQLExtendedFetch
SQLFetch
SQLFetchScroll
SQLForeignKeys
SQLGetData
SQLGetTypeInfo
SQLMoreResults
SQLNumParams
SQLNumResultCols
SQLParamData
SQLPrepare
SQLPrimaryKeys
SQLProcedureColumns
SQLProcedures
SQLPutData
SQLSetPos
SQLSpecialColumns
SQLStatistics
SQLTablePrivileges
SQLTables
HY009 Invalid use of null pointer
Can be returned from:
SQLAllocHandle
SQLBindParameter
SQLColumnPrivileges
SQLColumns
SQLExecDirect
SQLForeignKeys
SQLGetCursorName
SQLGetData
SQLGetFunctions
SQLPrepare
SQLPrimaryKeys
SQLProcedureColumns
SQLProcedures
SQLPutData
SQLSetConnectAttr
SQLSetCursorName
SQLSetEnvAttr
SQLSetStmtAttr
SQLSpecialColumns
SQLStatistics
SQLTablePrivileges
SQLTables
HY010 Function sequence error
Can be returned from:
SQLAllocHandle
SQLBindCol
SQLBindParameter
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
Can be returned from:
SQLParamData
SQLSetConnectAttr
SQLSetPos
SQLSetStmtAttr
HY012 Invalid transaction operation code
Can be returned from:
SQLEndTran
HY013 Memory Management err
Can be returned from all ODBC functions except:
SQLGetDiagField
SQLGetDiagRec
HY014 Limit on the number of handles exceeded
Can be returned from:
SQLAllocHandle
HY015 No cursor name available
Can be returned from:
SQLGetCursorName
HY016 Cannot modify an implementation row descriptor
Can be returned from:
SQLCopyDesc
SQLSetDescField
SQLSetDescRec
HY017 Invalid use of an automatically allocated descriptor handle
Can be returned from:
SQLFreeHandle
SQLSetStmtAttr
HY018 Server declined cancel request
Can be returned from:
SQLCancel
HY019 Non-character and non-binary data sent in pieces
Can be returned from:
SQLPutData
HY020 Attempt to concatenate a null value
Can be returned from:
SQLPutData
HY021 Inconsistent descriptor information
Can be returned from:
SQLBindParameter
SQLCopyDesc
SQLGetDescField
SQLSetDescField
SQLSetDescRec
HY024 Invalid attribute value
Can be returned from:
SQLSetConnectAttr
SQLSetEnvAttr
SQLSetStmtAttr
HY090 Invalid string or buffer length
Can be returned from:
SQLBindCol
SQLBindParameter
SQLBrowseConnect
SQLColAttribute
SQLColumnPrivileges
SQLColumns
SQLConnect
SQLDataSources
SQLDescribeCol
SQLDriverConnect
SQLDrivers
SQLExecDirect
SQLExecute
SQLFetch
SQLFetchScroll
SQLForeignKeys
SQLGetConnectAttr
SQLGetCursorName
SQLGetData
SQLGetDescField
SQLGetInfo
SQLGetStmtAttr
SQLParamData
SQLPrepare
SQLPrimaryKeys
SQLProcedureColumns
SQLProcedures
SQLPutData
SQLSetConnectAttr
SQLSetCursorName
SQLSetDescField
SQLSetDescRec
SQLSetEnvAttr
SQLSetStmtAttr
SQLSetPos
SQLSpecialColumns
SQLTablePrivileges
SQLStatistics
SQLTables
HY091 Invalid descriptor field identifier
Can be returned from:
SQLColAttribute
SQLGetDescField
SQLSetDescField
HY092 Invalid attribute/option identifier
Can be returned from:
SQLAllocHandle
SQLCopyDesc
SQLDriverConnect
SQLEndTran
SQLFreeStmt
SQLGetConnectAttr
SQLGetEnvAttr
SQLGetStmtAttr
SQLParamData
SQLSetConnectAttr
SQLSetDescField
SQLSetEnvAttr
SQLSetPos
SQLSetStmtAttr
HY095 Function type out of range
Can be returned from:
SQLGetFunctions
HY096 Invalid information type
Can be returned from:
SQLGetInfo
HY097 Column type out of range
Can be returned from:
SQLSpecial Columns
HY098 Scope type out of range
Can be returned from:
SQLSpecial Columns
HY099 Nullable type out of range
Can be returned from:
SQLSpecial Columns
HY100 Uniqueness option type out of range
Can be returned from:
SQLStatistics
HY101 Accuracy option type out of range
Can be returned from:
SQLStatistics
HY103 Invalid retrieval code
Can be returned from:
SQLDataSources
SQLDrivers
HY104 Invalid precision or scale value
Can be returned from:
SQLBindParameter
HY105 Invalid parameter type
Can be returned from:
SQLBindParameter
SQLExecDirect
SQLExecute
SQLParamData
SQLSetDescField
HY106 Fetch type out of range
Can be returned from:
SQLExtendedFetch
SQLFetchScroll
HY107 Row value out of range
Can be returned from:
SQLExtendedFetch
SQLFetch
SQLFetchScroll
SQLSetPos
HY109 Invalid cursor position
Can be returned from:
SQLExecDirect
SQLExecute
SQLGetData
SQLGetStmtAttr
SQLParamData
SQLSetPos
HY110 Invalid driver completion
Can be returned from:
SQLDriverConnect
HY111 Invalid bookmark value
Can be returned from:
SQLExtendedFetch
SQLFetchScroll
HYC00 Optional feature not implemented
Can be returned from:
SQLBindCol
SQLBindParameter
SQLColAttribute
SQLColumnPrivileges
SQLColumns
SQLDriverConnect
SQLEndTran
SQLConnect
SQLExecDirect
SQLExecute
SQLExtendedFetch
SQLFetch
SQLFetchScroll
SQLForeignKeys
SQLGetConnectAttr
SQLGetData
SQLGetEnvAttr
SQLSetPos
SQLGetInfo
SQLGetStmtAttr
SQLGetTypeInfo
SQLParamData
SQLPrepare
SQLPrimaryKeys
SQLProcedureColumns
SQLProcedures
SQLSetConnectAttr
SQLSetEnvAttr
SQLSetStmtAttr
SQLSpecialColumns
SQLStatistics
SQLTablePrivileges
SQLTables
HYT00 Timeout expired
Can be returned from:
SQLBrowseConnect
SQLColumnPrivileges
SQLColumns
SQLConnect
SQLDriverConnect
SQLExecDirect
SQLExecute
SQLExtendedFetch
SQLForeignKeys
SQLGetTypeInfo
SQLParamData
SQLPrepare
SQLPrimaryKeys
SQLProcedureColumns
SQLProcedures
SQLSetPos
SQLSpecialColumns
SQLStatistics
SQLTablePrivileges
SQLTables
HYT01 Connection timeout expired
Can be returned from all ODBC functions except:
SQLDrivers
SQLDataSources
SQLGetEnvAttr
SQLSetEnvAttr
IM001 Driver does not support this function
Can be returned from all ODBC functions except:
SQLAllocHandle
SQLDataSources
SQLDrivers
SQLFreeHandle
SQLGetFunctions
IM002 Data source name not found and no default driver
Can be returned from:
SQLConnect
IM003 Specified driver could not be loaded.
Can be returned from:
SQLConnect
IM004 Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
Can be returned from:
SQLDriverConnec
SQLConnect
SQLDriverConnect
IM005 Driver's SQLAllocHandle on SQL_HANDLE_DBC failed
Can be returned from:
SQLConnect
SQLDriverConnect
IM006 Driver's SQLSetConnectAttr Failed
Can be returned from:
SQLConnect
SQLDriverConnect
IM007 No data source or driver specified; dialog prohibited
Can be returned from:
SQLDriverConnect
IM008 Dialog failed
Can be returned from:
SQLDriverConnect
IM009 Unable to load translation DLL
Can be returned from:
SQLConnect
SQLDriverConnect
SQLSetConnectAttr
IM010 Data source name too long
Can be returned from:
SQLConnect
SQLDriverConnect
IM011 Driver name too long
Can be returned from:
SQLDriverConnect
IM012 DRIVER keyword syntax error
Can be returned from:
SQLDriverConnect
IM013 Trace file error
Can be returned from:
All ODBC functions
IM014 Invalid name of File DSN
Can be returned from:
SQLDriverConnect
IM015 Corrupt file data source
Can be returned from:
SQLDriverConnect
See also