ODBC Error Messages



NOTE: Use your browser to search for specific words or numbers!

SQLError returns SQLSTATE values as defined by the X/Open and SQL Access Group SQL CAE specification (1992). SQLSTATE values are strings that contain five characters. The following table lists SQLSTATE values that a driver can return for SQLError.

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 code 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 is for implementation defined conditions within the given class. The assignment of class and subclass values is defined by ANSI SQL-92.

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:SQLAllocEnv, 
SQLError
01002 Disconnect error SQLDisconnect
01004 Data truncated SQLBrowseConnect 
SQLColAttributes 
SQLDataSources 
SQLDescribeCol 
SQLDriverConnect 
SQLDrivers 
SQLExecDirect 
SQLExecute 
SQLExtendedFetch 
SQLFetch 
SQLGetCursorName 
SQLGetData 
SQLGetInfo 
SQLNativeSql 
SQLPutData 
SQLSetPos
01006 Privilege not revoked SQLExecDirect 
SQLExecute
01S00 Invalid connection string attribute SQLBrowseConnect 
SQLDriverConnect
01S01 Error in row SQLExtendedFetch 
SQLSetPos
01S02 Option value changed SQLConnect 
SQLExecDirect 
SQLExecute 
SQLPrepare 
SQLSetConnectOption 
SQLSetStmtOption
01S03 No rows updated or deleted SQLExecDirect 
SQLExecute 
SQLSetPos
01S04 More than one row updated or deleted SQLExecDirect 
SQLExecute 
SQLSetPos
01S05 Cancel treated as SQLFreeStmt with the SQL_CLOSE option SQLCancel
01S06 Attempt to fetch before the result set returned the first rowset SQLExtendedFetch
07001 Wrong number of parameters SQLExecDirect 
SQLExecute
07006 Restricted data type attribute violation SQLExecDirect 
SQLExecute 
SQLExtendedFetch 
SQLFetch 
SQLGetData 
SQLPutData
07S01 Invalid use of default parameter SQLExecDirect 
SQLExecute 
SQLPutData
08001 Unable to connect to data source SQLBrowseConnect 
SQLConnect 
SQLDriverConnect
08002 Connection in use SQLBrowseConnect 
SQLConnect 
SQLDriverConnect 
SQLSetConnectOption
08003 Connection not open SQLAllocStmt 
SQLDisconnect 
SQLGetConnectOption 
SQLGetInfo 
SQLNativeSql 
SQLSetConnectOption 
SQLTransact
08004 Data source rejected establishment of connection SQLBrowseConnect 
SQLConnect 
SQLDriverConnect
08007 Connection failure during transaction SQLTransact
08S01 Communication link failure SQLBrowseConnect 
SQLColumnPrivileges 
SQLColumns 
SQLConnect 
SQLDriverConnect 
SQLExecDirect 
SQLExecute 
SQLExtendedFetch 
SQLFetch 
SQLForeignKeys 
SQLFreeConnect 
SQLGetData 
SQLGetTypeInfo 
SQLParamData 
SQLPrepare 
SQLPrimaryKeys 
SQLProcedureColumns 
SQLProcedures 
SQLPutData 
SQLSetConnectOption 
SQLSetStmtOption 
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 SQLExecDirect 
SQLPrepare 
SQLSetPos
22001 String data right truncation SQLPutData
22002 Indicator variable required but not supplied SQLExecDirect 
SQLExecute 
SQLExtendedFetch 
SQLFetch 
SQLGetData 
SQLMoreResults 
SQLParamData
22003 Numeric value out of range SQLExecDirect 
SQLExecute 
SQLExtendedFetch 
SQLFetch 
SQLGetData 
SQLGetInfo 
SQLPutData 
SQLSetPos
22005 Error in assignment SQLExecDirect 
SQLExecute 
SQLGetData 
SQLPrepare 
SQLPutData 
SQLSetPos
22008 Datetime field overflow SQLExecDirect 
SQLExecute 
SQLGetData 
SQLPutData 
SQLSetPos
22012 Division by zero SQLExecDirect 
SQLExecute 
SQLExtendedFetch 
SQLFetch
22026 String data, length mismatch SQLParamData
23000 Integrity constraint violation SQLExecDirect 
SQLExecute 
SQLSetPos 
SQLSTATE 
Error Can be returned from
24000 Invalid cursor state SQLColAttributes 
SQLColumnPrivileges 
SQLColumns 
SQLDescribeCol 
SQLExecDirect 
SQLExecute 
SQLExtendedFetch 
SQLFetch 
SQLForeignKeys 
SQLGetData 
SQLGetStmtOption 
SQLGetTypeInfo 
SQLNativeSql 
SQLPrepare 
SQLPrimaryKeys 
SQLProcedureColumns 
SQLProcedures 
SQLSetConnectOption 
SQLSetCursorName 
SQLSetPos 
SQLSetStmtOption 
SQLSpecialColumns 
SQLStatistics 
SQLTablePrivileges 
SQLTables
25000 Invalid transaction state SQLDisconnect
28000 Invalid authorization specification SQLBrowseConnect 
SQLConnect 
SQLDriverConnect
34000 Invalid cursor name SQLExecDirect 
SQLPrepare 
SQLSetCursorName
37000 Syntax error or access violation SQLExecDirect 
SQLNativeSql 
SQLPrepare
3C000 Duplicate cursor name SQLSetCursorName
40001 Serialization failure SQLExecDirect 
SQLExecute 
SQLExtendedFetch 
SQLFetch
42000 Syntax error or access violation SQLExecDirect 
SQLExecute 
SQLPrepare 
SQLSetPos
70100 Operation aborted SQLCancel
IM001 Driver does not support this function All ODBC functions except:SQLAllocConnect 
SQLAllocEnv 
SQLDataSources 
SQLDrivers 
SQLError 
SQLFreeConnect 
SQLFreeEnv 
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 SQLAllocEnv failed SQLBrowseConnect 
SQLConnect 
SQLDriverConnect
IM005 Driver's SQLAllocConnect failed SQLBrowseConnect 
SQLConnect 
SQLDriverConnect
IM006 Driver's SQLSetConnect-Option 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 
SQLSetConnectOption
IM010 Data source name too long SQLBrowseConnect 
SQLDriverConnect
IM011 Driver name too long SQLBrowseConnect 
SQLDriverConnect
IM012 DRIVER keyword syntax error SQLBrowseConnect 
SQLDriverConnect
IM013 Trace file error All ODBC functions. 
S0001 Base table or view already exists SQLExecDirect 
SQLPrepare
S0002 Base table not found SQLExecDirect 
SQLPrepare
S0011 Index already exists SQLExecDirect 
SQLPrepare
S0012 Index not found SQLExecDirect 
SQLPrepare
S0021 Column already exists SQLExecDirect 
SQLPrepare
S0022 Column not found SQLExecDirect 
SQLPrepare
S0023 No default for column SQLSetPos
S1000 General error All ODBC functions except:SQLAllocEnv 
SQLError
S1001 Memory allocation failure All ODBC functions except:SQLAllocEnv 
SQLError 
SQLFreeConnect 
SQLFreeEnv
S1002 Invalid column number SQLBindCol 
SQLColAttributes 
SQLDescribeCol 
SQLExtendedFetch 
SQLFetch 
SQLGetData
S1003 Program type out of range SQLBindCol 
SQLBindParameter 
SQLGetData
S1004 SQL data type out of range SQLBindParameter 
SQLGetTypeInfo 
SQLSTATE Error Can be returned from
S1008 Operation canceled All ODBC functions that can be processed asynchronously:SQLColAttributes 
SQLColumnPrivileges 
SQLColumns 
SQLDescribeCol 
SQLDescribeParam 
SQLExecDirect 
SQLExecute 
SQLExtendedFetch 
SQLFetch 
SQLForeignKeys 
SQLGetData 
SQLGetTypeInfo 
SQLMoreResults 
SQLNumParams 
SQLNumResultCols 
SQLParamData 
SQLPrepare 
SQLPrimaryKeys 
SQLProcedureColumns 
SQLProcedures 
SQLPutData 
SQLSetPos 
SQLSpecialColumns 
SQLStatistics 
SQLTablePrivileges 
SQLTables
S1009 Invalid argument value SQLAllocConnect 
SQLAllocStmt 
SQLBindCol 
SQLBindParameter 
SQLExecDirect 
SQLForeignKeys 
SQLGetData 
SQLGetInfo 
SQLNativeSql 
SQLPrepare 
SQLPutData 
SQLSetConnectOption 
SQLSetCursorName 
SQLSetPos 
SQLSetStmtOption
S1010 Function sequence error SQLBindCol 
SQLBindParameter 
SQLColAttributes 
SQLColumnPrivileges 
SQLColumns 
SQLDescribeCol 
SQLDescribeParam 
SQLDisconnect 
SQLExecDirect 
SQLExecute 
SQLExtendedFetch 
SQLFetch 
SQLForeignKeys 
SQLFreeConnect 
SQLFreeEnv 
SQLFreeStmt 
SQLGetConnectOption 
SQLGetCursorName 
SQLGetData 
SQLGetFunctions 
SQLGetStmtOption 
SQLGetTypeInfo 
SQLMoreResults 
SQLNumParams 
SQLNumResultCols 
SQLParamData 
SQLParamOptions 
SQLPrepare 
SQLPrimaryKeys 
SQLProcedureColumns 
SQLProcedures 
SQLPutData 
SQLRowCount 
SQLSetConnectOption 
SQLSetCursorName 
SQLSetPos 
SQLSetScrollOptions 
SQLSetStmtOption 
SQLSpecialColumns 
SQLStatistics 
SQLTablePrivileges 
SQLTables 
SQLTransact
S1011 Operation invalid at this time SQLGetStmtOption 
SQLSetConnectOption 
SQLSetStmtOption
S1012 Invalid transaction operation code specified SQLTransact
S1015 No cursor name available SQLGetCursorName
S1090 Invalid string or buffer length SQLBindCol 
SQLBindParameter 
SQLBrowseConnect 
SQLColAttributes 
SQLColumnPrivileges 
SQLColumns 
SQLConnect 
SQLDataSources 
SQLDescribeCol 
SQLDriverConnect 
SQLDrivers 
SQLExecDirect 
SQLExecute 
SQLForeignKeys 
SQLGetCursorName 
SQLGetData 
SQLGetInfo 
SQLNativeSql 
SQLPrepare 
SQLPrimaryKeys 
SQLProcedureColumns 
SQLProcedures 
SQLPutData 
SQLSetCursorName 
SQLSetPos 
SQLSpecialColumns 
SQLStatistics 
SQLTablePrivileges 
SQLTables
S1091 Descriptor type out of range SQLColAttributes
S1092 Option type out of range SQLFreeStmt 
SQLGetConnectOption 
SQLGetStmtOption 
SQLSetConnectOption 
SQLSetStmtOption
S1093 Invalid parameter number SQLBindParameter 
SQLDescribeParam 
SQLSTATE Error Can be returned from
S1095 Function type out of range SQLGetFunctions
S1096 Information type out of range SQLGetInfo
S1097 Column type out of range SQLSpecialColumns
S1098 Scope type out of range SQLSpecialColumns
S1099 Nullable type out of range SQLSpecialColumns
S1100 Uniqueness option type out of range SQLStatistics
S1101 Accuracy option type out of range SQLStatistics
S1103 Direction option out of range SQLDataSources 
SQLDrivers
S1105 Invalid parameter type SQLBindParameter 
SQLExecDirect 
SQLExecute
S1106 Fetch type out of range SQLExtendedFetch
S1107 Row value out of range  SQLExtendedFetch 
SQLParamOptions 
SQLSetPos 
SQLSetScrollOptions
S1108 Concurrency option out of range SQLSetScrollOptions
S1109 Invalid cursor position SQLExecute 
SQLExecDirect 
SQLGetData 
SQLGetStmtOption 
SQLNativeSql 
SQLSetPos
S1110 Invalid driver completion SQLDriverConnect
S1111 Invalid bookmark value SQLExtendedFetch
S1C00 Driver not capable SQLBindCol 
SQLBindParameter 
SQLColAttributes 
SQLColumnPrivileges 
SQLColumns 
SQLExecDirect 
SQLExecute 
SQLExtendedFetch 
SQLFetch 
SQLForeignKeys 
SQLGetConnectOption 
SQLGetData 
SQLGetInfo 
SQLGetStmtOption 
SQLGetTypeInfo 
SQLPrimaryKeys 
SQLProcedureColumns 
SQLProcedures 
SQLSetConnectOption 
SQLSetPos 
SQLSetScrollOptions 
SQLSetStmtOption 
SQLSpecialColumns 
SQLStatistics 
SQLTablePrivileges 
SQLTables 
SQLTransact
S1T00 Timeout expired SQLBrowseConnect 
SQLColAttributes 
SQLColumnPrivileges 
SQLColumns 
SQLConnect 
SQLDescribeCol 
SQLDescribeParam 
SQLDriverConnect 
SQLExecDirect 
SQLExecute 
SQLExtendedFetch 
SQLFetch 
SQLForeignKeys 
SQLGetData 
SQLGetInfo 
SQLMoreResults 
SQLNumParams 
SQLNumResultCols 
SQLParamData 
SQLPrepare 
SQLPrimaryKeys 
SQLProcedureColumns 
SQLProcedures 
SQLPutData 
SQLSetPos 
SQLSpecialColumns 
SQLStatistics 
SQLTablePrivileges 
SQLTables

Picture
8111 LBJ Freeway, Suite 860
Dallas, TX 75251
(800) 442-9273 or (214) 691-4700