The ODBC cursor library returns the following SQLSTATEs in addition to those listed in Chapter 21, “ODBC Function Reference.”
Note The cursor library does not order status records; the Driver Manager and ODBC 3.x drivers are responsible for ordering status records.
SQLSTATE | Description | Can be returned from |
01000 | Cursor is not updatable. | SQLFetch SQLFetchScroll |
01000 | Cursor library not used. Load failed. | SQLBrowseConnect SQLConnect SQLDriverConnect |
01000 | Cursor library not used. Insufficient driver support. | SQLBrowseConnect SQLConnect SQLDriverConnect |
01000 | Cursor library not used. Version mismatch with Driver Manager. | SQLBrowseConnect SQLConnect SQLDriverConnect |
01000 | Driver returned SQL_SUCCESS_WITH_INFO. The warning message has been lost. | SQLFetch SQLFetchScroll |
S1000 | General error: Unable to create file buffer. | SQLFetch SQLFetchScroll SQLGetData |
S1000 | General error: Unable to read from file buffer. | SQLFetch SQLFetchScroll SQLGetData |
S1000 | General error: Unable to write to file buffer. | SQLFetch SQLFetchScroll SQLGetData |
S1000 | General error: Unable to close or remove file buffer. | SQLFreeHandle SQLFreeStmt |
SL001 | Positioned request cannot be performed because no searchable columns were bound. | SQLExecDirect SQLGetData SQLPrepare |
SL002 | Positioned request could not be performed because result set was created by a join condition. | SQLExecute SQLExecDirect SQLGetData |
SL003 | Bound buffer exceeds maximum segment size. | SQLFetch SQLFetchScroll |
SL004 | Result set was not generated by a SELECT statement. | SQLGetData |
SL005 | SELECT statement contains a GROUP BY clause. | SQLGetData |
SL006 | Parameter arrays are not supported with positioned requests. | SQLPrepare SQLExecDirect |
SL008 | SQLGetData is not allowed on a forward-only (non-buffered) cursor. | SQLGetData |
SL009 | No columns were bound prior to calling SQLFetch or SQLFetchScroll. | SQLFetch SQLFetchScroll |
SL010 | SQLBindCol returned SQL_ERROR during an attempt to bind to an internal buffer. | SQLFetch SQLFetchScroll SQLGetData |
SL011 | Statement option is only valid after calling SQLFetch or SQLFetchScroll. | SQLGetStmtAttr |
SL012 | Statement bindings may not be changed while a cursor is open. | SQLBindCol SQLFreeHandle SQLFreeStmt SQLSetStmtAttr |
SL014 | A positioned request was issued and not all column count fields were buffered. | SQLExecDirect SQLExecute SQLPrepare |
SL015 | SQLFetch and SQLFetchScroll cannot be mixed. | SQLExtendedFetch SQLFetch SQLFetchScroll |