SQLSTATE |
Error |
Can be returned from |
HY000 |
General error |
- An error occurred for which there was no specific
SQLSTATE and for which no implementation-specific SQLSTATE was defined. The error message returned by SQLGetDiagRec in the *MessageText buffer describes the error and its cause.
- All ODBC functions except:
SQLError
SQLGetDiagField
SQLGetDiagRec
|
HY001 |
Memory allocation error |
|
HY003 |
Invalid application buffer type |
-
SQLBindCol
The argument TargetType was neither a valid data type nor SQL_C_DEFAULT .
-
SQLBindParameter
The value specified by the argument ValueType was not a valid C data type or SQL_C_DEFAULT .
-
SQLGetData
(Driver Manager.) The argument TargetType was neither a valid data type, SQL_C_DEFAULT , nor SQL_ARD_TYPE .
(Driver Manager.) The argument ColumnNumber was 0, and the argument TargetType was not SQL_C_BOOKMARK for a fixed-length bookmark or SQL_C_VARBOOKMARK for a variable-length bookmark.
|
HY004 |
Invalid SQL data type |
-
SQLBindParameter
The value specified for the argument ParameterType was neither a valid ODBC SQL data type identifier nor a driver-specific SQL data type identifier supported by the ODBC driver.
-
SQLGetTypeInfo
The value specified for the argument DataType was neither a valid ODBC SQL data type identifier nor a driver-specific data type identifier supported by the ODBC driver.
|
HY007 |
Associated statement is not prepared |
-
SQLCopyDesc
SourceDescHandle was associated with an IRD , and the associated statement handle was not in the prepared or executed state.
-
SQLGetDescField
DescriptorHandle was associated with a StatementHandle as an IRD , and the associated statement handle had not been prepared or executed.
-
SQLGetDescRec
DescriptorHandle was associated with an IRD , and the associated statement handle was not in the prepared or executed state.
|
HY008 |
Operation cancelled |
- All ODBC functions that can be processed asynchronously
-
SQLBulkOperations , SQLColAttribute , SQLColumnPrivileges , SQLColumns , SQLDescribeCol , SQLDescribeParam , SQLExecDirect , SQLExecute , SQLExtendedFetch , SQLFetch , SQLFetchScroll , SQLForeignKeys , SQLGetTypeInfo , SQLMoreResults , SQLNumParams , SQLNumResultCols , SQLParamData , SQLPrepare , SQLPrimaryKeys , SQLProcedureColumns , SQLProcedures , SQLPutData , SQLSetPos , SQLSpecialColumns , SQLStatistics , SQLTablePrivileges , SQLTables
Asynchronous processing was enabled for the StatementHandle .
The function was called, and before it completed execution, SQLCancel was called on the StatementHandle . Then the function was called again on the StatementHandle .
The function was called, and before it completed execution, SQLCancel was called on the StatementHandle from a different thread in a multithread application.
-
SQLGetData
Asynchronous processing was enabled for the StatementHandle . The function was called, and before it completed execution, SQLCancel was called on the StatementHandle , and then the function was called again on the StatementHandle .
The function was called, and before it completed execution, SQLCancel was called on the StatementHandle from a different thread in a multithread application, and then the function was called again on the StatementHandle .
|
HY009 |
Invalid use of null pointer |
-
SQLAllocHandle
(Driver Manager.) The OutputHandlePtr argument was a null pointer.
-
SQLBindParameter
(Driver Manager.) The argument ParameterValuePtr was a null pointer, the argument StrLen_or_IndPtr was a null pointer, and the argument InputOutputType was not SQL_PARAM_OUTPUT .
(Driver Manager.) SQL_PARAM_OUTPUT , where the argument ParameterValuePtr was a null pointer, the C type was char or binary , and the BufferLength (cbValueMax ) was greater than 0.
SQLBulkOperations
-
SQLColumnPrivileges
The TableName argument was a null pointer.
The SQL_ATTR_METADATA_ID statement attribute was set to SQL_TRUE , the CatalogName argument was a null pointer, and the SQL_CATALOG_NAME InfoType returns that catalog names are supported.
(Driver Manager.) The SQL_ATTR_METADATA_ID statement attribute was set to SQL_TRUE , and the SchemaName or ColumnName argument was a null pointer.
-
SQLColumns
The SQL_ATTR_METADATA_ID statement attribute was set to SQL_TRUE , the CatalogName argument was a null pointer, and the SQL_CATALOG_NAME InfoType returns that catalog names are supported.
(Driver Manager.) The SQL_ATTR_METADATA_ID statement attribute was set to SQL_TRUE , and the SchemaName , TableName , or ColumnName argument was a null pointer.
-
SQLExecDirect
(Driver Manager.) *StatementText was a null pointer.
-
SQLForeignKeys
(Driver Manager.) The arguments PKTableName and FKTableName were both null pointers.
The SQL_ATTR_METADATA_ID statement attribute was set to SQL_TRUE , the FKCatalogName or PKCatalogName argument was a null pointer, and the SQL_CATALOG_NAME InfoType returns that catalog names are supported.
(Driver Manager.) The SQL_ATTR_METADATA_ID statement attribute was set to SQL_TRUE , and the FKSchemaName , PKSchemaName , FKTableName , or PKTableName argument was a null pointer.
SQLGetCursorName
-
SQLGetData
(Driver Manager.) The argument CursorName was a null pointer.
SQLGetFunctions
-
SQLNativeSql
(Driver Manager.) *InStatementText was a null pointer.
-
SQLPrepare
(Driver Manager.) StatementText was a null pointer.
-
SQLPrimaryKeys
(Driver Manager.) The TableName argument was a null pointer.
The SQL_ATTR_METADATA_ID statement attribute was set to SQL_TRUE , the CatalogName argument was a null pointer, and SQLGetInfo with the SQL_CATALOG_NAME information type returns that catalog names are supported.
(Driver Manager.) The SQL_ATTR_METADATA_ID statement attribute was set to SQL_TRUE , and the SchemaName argument was a null pointer.
-
SQLProcedureColumns
The SQL_ATTR_METADATA_ID statement attribute was set to SQL_TRUE , the CatalogName argument was a null pointer, and the SQL_CATALOG_NAME InfoType returns that catalog names are supported.
(Driver Manager.) The SQL_ATTR_METADATA_ID statement attribute was set to SQL_TRUE , and the SchemaName , ProcName , or ColumnName argument was a null pointer.
-
SQLProcedures
The SQL_ATTR_METADATA_ID statement attribute was set to SQL_TRUE , the CatalogName argument was a null pointer, and the SQL_CATALOG_NAME InfoType returns that catalog names are supported.
(Driver Manager.) The SQL_ATTR_METADATA_ID statement attribute was set to SQL_TRUE , and the SchemaName or ProcName argument was a null pointer.
-
SQLPutData
(Driver Manager.) The argument DataPtr was a null pointer, and the argument StrLen_or_Ind was not 0, SQL_DEFAULT_PARAM , or SQL_NULL_DATA .
-
SQLSetConnectAttr
The Attribute argument identified a connection attribute that required a string value, and the ValuePtr argument was a null pointer.
-
SQLSetCursorName
(Driver Manager.) The argument CursorName was a null pointer.
-
SQLSetEnvAttr
The Attribute argument identified an environment attribute that required a string value, and the ValuePtr argument was a null pointer.
-
SQLSetStmtAttr
The Attribute argument identified a statement attribute that required a string attribute, and the ValuePtr argument was a null pointer.
-
SQLSpecialColumns , SQLStatistics , SQLTablePrivileges , SQLTables
The TableName argument was a null pointer.
The SQL_ATTR_METADATA_ID statement attribute was set to SQL_TRUE , the CatalogName argument was a null pointer, and the SQL_CATALOG_NAME InfoType returns that catalog names are supported.
(Driver Manager.) The SQL_ATTR_METADATA_ID statement attribute was set to SQL_TRUE , and the SchemaName argument was a null pointer.
|
HY010 |
Function sequence error |
SQLAllocHandle
-
SQLBindCol , SQLBindParameter , SQLCloseCursor , SQLColumnPrivileges , SQLColumns
(Driver Manager.) An asynchronously executing function was called for the StatementHandle and was still executing when this function was called.
(Driver Manager.) SQLExecute , SQLExecDirect , SQLBulkOperations , or SQLSetPos was called for the StatementHandle and returned SQL_NEED_DATA . This function was called before data was sent for all data-at-execution parameters or columns.
-
SQLBulkOperations
(Driver Manager.) The specified StatementHandle was not in an executed state. The function was called without first calling SQLExecDirect , SQLExecute , or a catalog function.
(Driver Manager.) An asynchronously executing function (not this one) was called for the StatementHandle and was still executing when this function was called.
(Driver Manager.) SQLExecute , SQLExecDirect , or SQLSetPos was called for the StatementHandle and returned SQL_NEED_DATA . This function was called before data was sent for all data-at-execution parameters or columns.
(Driver Manager.) The ODBC driver was an ODBC 2.x driver, and SQLBulkOperations was called for a StatementHandle before SQLFetchScroll or SQLFetch was called.
(Driver Manager.) SQLBulkOperations was called after SQLExtendedFetch was called on the StatementHandle .
-
SQLColAttribute , SQLDescribeCol , SQLDescribeParam , SQLNumParams , SQLNumResultCols , SQLRowCount
(Driver Manager.) The function was called prior to calling SQLPrepare , SQLExecDirect , or a catalog function for the StatementHandle .
(Driver Manager.) An asynchronously executing function (not this one) was called for the StatementHandle and was still executing when this function was called.
(Driver Manager.) SQLExecute , SQLExecDirect , SQLBulkOperations , or SQLSetPos was called for the StatementHandle and returned SQL_NEED_DATA . This function was called before data was sent for all data-at-execution parameters or columns.
-
SQLCopyDesc
(Driver Manager.) The descriptor handle in SourceDescHandle or TargetDescHandle was associated with a StatementHandle for which an asynchronously executing function (not this one) was called and was still executing when this function was called.
(Driver Manager.) The descriptor handle in SourceDescHandle or TargetDescHandle was associated with a StatementHandle for which SQLExecute , SQLExecDirect , SQLBulkOperations , or SQLSetPos was called and returned SQL_NEED_DATA . This function was called before data was sent for all data-at-execution parameters or columns.
-
SQLDisconnect , SQLEndTran
(Driver Manager.) An asynchronously executing function was called for a StatementHandle associated with the ConnectionHandle and was still executing when SQLDisconnect was called.
(Driver Manager.) SQLExecute , SQLExecDirect , SQLBulkOperations , or SQLSetPos was called for a StatementHandle associated with the ConnectionHandle and returned SQL_NEED_DATA . This function was called before data was sent for all data-at-execution parameters or columns.
-
SQLExecDirect , SQLExecute , SQLForeignKeys , SQLFreeStmt , SQLGetCursorName
(Driver Manager.) An asynchronously executing function (not this one) was called for the StatementHandle and was still executing when this function was called.
(Driver Manager.) SQLExecute , SQLExecDirect , SQLBulkOperations , or SQLSetPos was called for the StatementHandle and returned SQL_NEED_DATA . This function was called before data was sent for all data-at-execution parameters or columns.
-
SQLExtendedFetch
(Driver Manager.) The specified StatementHandle was not in an executed state. The function was called without first calling SQLExecDirect , SQLExecute , or a catalog function.
(Driver Manager.) An asynchronously executing function (not this one) was called for the StatementHandle and was still executing when this function was called.
(Driver Manager.) SQLExecute , SQLExecDirect , SQLBulkOperations , or SQLSetPos was called for the StatementHandle and returned SQL_NEED_DATA . This function was called before data was sent for all data-at-execution parameters or columns.
(Driver Manager.) SQLExtendedFetch was called for the StatementHandle after SQLFetch or SQLFetchScroll was called and before SQLFreeStmt was called with the SQL_CLOSE option.
(Driver Manager.) SQLBulkOperations was called for a statement before SQLFetch , SQLFetchScroll , or SQLExtendedFetch was called, and then SQLExtendedFetch was called before SQLFreeStmt was called
with the SQL_CLOSE option.
-
SQLFetch , SQLFetchScroll
(Driver Manager.) The specified StatementHandle was not in an executed state. The function was called without first callingSQLExecDirect , SQLExecute or a catalog function.
(Driver Manager.) An asynchronously executing function (not this one) was called for the StatementHandle and was still executing when this function was called.
(Driver Manager.) SQLExecute ,SQLExecDirect , SQLBulkOperations , or SQLSetPos was called for the StatementHandle and returned SQL_NEED_DATA . This function was called before data was sent for all data-at-execution parameters or columns.
(Driver Manager.) SQLFetch was called for the StatementHandle after SQLExtendedFetch was called and before SQLFreeStmt with the SQL_CLOSE option was called.
-
SQLFreeHandle
(Driver Manager.) The HandleType argument was SQL_HANDLE_ENV , and at least one connection was in an allocated or connected state. SQLDisconnect and SQLFreeHandle with a HandleType of SQL_HANDLE_DBC must be called for each connection before calling SQLFreeHandle with a HandleType of SQL_HANDLE_ENV .
(Driver Manager.) The HandleType argument was SQL_HANDLE_DBC , and the function was called before calling SQLDisconnect for the connection.
(Driver Manager.) The HandleType argument was SQL_HANDLE_STMT ; an asynchronously executing function was called on the statement handle; and the function was still executing when this function was called.
(Driver Manager.) The HandleType argument was SQL_HANDLE_STMT ; SQLExecute ,SQLExecDirect , SQLBulkOperations , or SQLSetPos was called with the statement handle and returned SQL_NEED_DATA . This function was called before data was sent for all data-at-execution parameters or columns.
(Driver Manager.) All subsidiary handles and other resources were not released before SQLFreeHandle was called.
-
SQLGetConnectAttr
(Driver Manager.) SQLBrowseConnect was called for the ConnectionHandle and returned SQL_NEED_DATA . This function was called before SQLBrowseConnect returned SQL_SUCCESS_WITH_INFO or SQL_SUCCESS .
-
SQLGetData
(Driver Manager.) The specified StatementHandle was not in an executed state. The function was called without first callingSQLExecDirect , SQLExecute or a catalog function.
(Driver Manager.) An asynchronously executing function (not this one) was called for the StatementHandle and was still executing when this function was called.
(Driver Manager.) SQLExecute ,SQLExecDirect , SQLBulkOperations , or SQLSetPos was called for the StatementHandle and returned SQL_NEED_DATA . This function was called before data was sent for all data-at-execution parameters or columns.
(Driver Manager.) The StatementHandle was in an executed state, but no result set was associated with the StatementHandle .
-
SQLGetDescField , SQLGetDescRec
(Driver Manager.) DescriptorHandle was associated with a StatementHandle for which an asynchronously executing function (not this one) was called and was still executing when this function was called.
(Driver Manager.) DescriptorHandle was associated with a StatementHandle for which SQLExecute ,SQLExecDirect , SQLBulkOperations , or SQLSetPos was called and returned SQL_NEED_DATA . This function was called before data was sent for all data-at-execution parameters or columns.
-
SQLGetFunctions
(Driver Manager.) SQLGetFunctions was called before SQLConnect , SQLBrowseConnect , or SQLDriverConnect .
(Driver Manager.) SQLBrowseConnect was called for the ConnectionHandle and returned SQL_NEED_DATA . This function was called before SQLBrowseConnect returned SQL_SUCCESS_WITH_INFO or SQL_SUCCESS .
-
SQLGetStmtAttr , SQLGetTypeInfo , SQLMoreResults
(Driver Manager.) An asynchronously executing function was called for the StatementHandle and was still executing when this function was called.
(Driver Manager.) SQLExecute ,SQLExecDirect , SQLBulkOperations , or SQLSetPos was called for the StatementHandle and returned SQL_NEED_DATA . This function was called before data was sent for all data-at-execution parameters or columns.
-
SQLParamData
(Driver Manager.) The previous function call was not a call toSQLExecDirect , SQLExecute , SQLBulkOperations , or SQLSetPos where the return code was SQL_NEED_DATA , or the previous function call was a call to SQLPutData .
The previous function call was a call to SQLParamData .
(Driver Manager.) An asynchronously executing function (not this one) was called for the StatementHandle and was still executing when this function was called.
SQLExecute ,SQLExecDirect , SQLBulkOperations , or SQLSetPos was called for the StatementHandle and returned SQL_NEED_DATA . SQLCancel was called before data was sent for all data-at-execution parameters or columns.
-
SQLPrepare , SQLPrimaryKeys , SQLProcedureColumns , SQLProcedures , SQLSetCursorName , SQLSetStmtAttr , SQLSpecialColumns , SQLStatistics , SQLTablePrivileges , SQLTables
(Driver Manager.) An asynchronously executing function (not this one) was called for the StatementHandle and was still executing when this function was called.
(Driver Manager.)SQLExecute ,SQLExecDirect , SQLBulkOperations , or SQLSetPos was called for the StatementHandle and returned SQL_NEED_DATA . This function was called before data was sent for all data-at-execution parameters or columns.
-
SQLPutData
(Driver Manager.) The previous function call was not a call to SQLPutData or SQLParamData .
(Driver Manager.) An asynchronously executing function (not this one) was called for the StatementHandle and was still executing when this function was called.
-
SQLSetConnectAttr
(Driver Manager.) An asynchronously executing function was called for a StatementHandle associated with the ConnectionHandle and was still executing when SQLSetConnectAttr was called.
(Driver Manager.)SQLExecute ,SQLExecDirect , SQLBulkOperations , or SQLSetPos was called for a StatementHandle associated with the ConnectionHandle and returned SQL_NEED_DATA . This function was called before data was sent for all data-at-execution parameters or columns.
(Driver Manager.) SQLBrowseConnect was called for the ConnectionHandle and returned SQL_NEED_DATA . This function was called before SQLBrowseConnect returned SQL_SUCCESS_WITH_INFO or SQL_SUCCESS .
-
SQLSetDescField , SQLSetDescRec
(Driver Manager.) The DescriptorHandle was associated with a StatementHandle for which an asynchronously executing function (not this one) was called and was still executing when this function was called.
(Driver Manager.)SQLExecute ,SQLExecDirect , SQLBulkOperations , or SQLSetPos was called for the StatementHandle with which the DescriptorHandle was associated and returned SQL_NEED_DATA . This function was called before data was sent for all data-at-execution parameters or columns.
-
SQLSetEnvAttr
(Driver Manager.) A connection handle has been allocated on EnvironmentHandle .
-
SQLSetPos
(Driver Manager.) The specified StatementHandle was not in an executed state. The function was called without first callingSQLExecDirect ,SQLExecute , or a catalog function.
(Driver Manager.) An asynchronously executing function (not this one) was called for the StatementHandle and was still executing when this function was called.
(Driver Manager.)SQLExecute ,SQLExecDirect , SQLBulkOperations , or SQLSetPos was called for the StatementHandle and returned SQL_NEED_DATA . This function was called before data was sent for all data-at-execution parameters or columns.
(Driver Manager.) The ODBC driver was an ODBC 2.x driver, and SQLSetPos was called for a StatementHandle after SQLFetchScroll was called.
|
HY011 |
Attribute cannot be set now |
|
HY012 |
Invalid transaction operation code |
|
HY013 |
Memory management error |
-
SQLAllocHandle
The HandleType argument was SQL_HANDLE_DBC , SQL_HANDLE_STMT , or SQL_HANDLE_DESC ; and the function call could not be processed because the underlying memory objects could not be accessed, possibly because of low memory conditions.
-
SQLBindCol , SQLBindParameter , SQLBrowseConnect , SQLBulkOperations , SQLCancel , SQLCloseCursor , SQLColAttribute , SQLColumnPrivileges , SQLColumns , SQLConnect , SQLCopyDesc , SQLDataSources , SQLDescribeCol , SQLDescribeParam , SQLDisconnect , SQLDriverConnect , SQLDrivers , SQLEndTran ,SQLExecDirect ,SQLExecute , SQLExtendedFetch , SQLFetchScroll , SQLForeignKeys , SQLFreeStmt , SQLGetConnectAttr , SQLGetCursorName , SQLGetData , SQLGetEnvAttr , SQLGetFunctions , SQLGetInfo , SQLGetStmtAttr , SQLGetTypeInfo , SQLMoreResults , SQLNativeSql , SQLNumParams , SQLNumResultCols , SQLParamData , SQLPrepare , SQLPrimaryKeys , SQLProcedures , SQLPutData , SQLRowCount , SQLSetConnectAttr , SQLSetCursorName , SQLSetDescField , SQLSetDescRec , SQLSetEnvAttr , SQLSetPos , SQLSetStmtAttr , SQLSpecialColumns SQLStatistics , SQLTablePrivileges , SQLTables
The function call could not be processed because the underlying memory objects could not be accessed, possibly because of low memory conditions.
-
SQLFreeHandle
The HandleType argument was SQL_HANDLE_STMT or SQL_HANDLE_DESC , and the function call could not be processed because the underlying memory objects could not be accessed, possibly because of low memory conditions.
- All ODBC functions except:
SQLGetDiagField
The function call could not be processed because the underlying memory objects could not be accessed, possibly because of low memory conditions. SQLGetDiagRec
The function call could not be processed because the underlying memory objects could not be accessed, possibly because of low memory conditions.
|
HY014 |
Limit on the number of handles exceeded |
|
HY015 |
No cursor name available |
|
HY016 |
Cannot modify an implementation row descriptor |
-
SQLCopyDesc
TargetDescHandle was associated with an IRD .
-
SQLSetDescField
The DescriptorHandle argument was associated with an IRD , and the FieldIdentifier argument was not SQL_DESC_ARRAY_STATUS_PTR or SQL_DESC_ROWS_PROCESSED_PTR .
-
SQLSetDescRec
The DescriptorHandle argument was associated with an IRD .
|
HY017 |
Invalid use of an automatically allocated descriptor handle |
-
SQLFreeHandle
(Driver Manager.) The Handle argument was set to the handle for an automatically allocated descriptor.
-
SQLSetStmtAttr
(Driver Manager.) The Attribute argument was SQL_ATTR_IMP_ROW_DESC or SQL_ATTR_IMP_PARAM_DESC .
(Driver Manager.) The Attribute argument was SQL_ATTR_APP_ROW_DESC or SQL_ATTR_APP_PARAM_DESC , and the value in ValuePtr was an implicitly allocated descriptor handle other than the handle originally allocated for the ARD or APD .
|
HY018 |
Server declined cancel request |
|
HY019 |
Non-character and non-binary data sent in pieces |
-
SQLPutData
SQLPutData was called more than once for a parameter or column, and it was not being used to send character C data to a column with a character, binary, or data source-specific data type or to send binary C data to a column with a character, binary, or data source-specific data type.
|
HY020 |
Attempt to concatenate a null value |
|
HY021 |
Inconsistent descriptor information |
-
SQLBindParameter
The descriptor information checked during a consistency check was not consistent. (Refer to the "Consistency Checks" section in SQLSetDescField .)
The value specified for the argument DecimalDigits was outside the range of values supported by the data source for a column of the SQL data type specified by the ParameterType argument.
-
SQLCopyDesc
The descriptor information checked during a consistency check was not consistent. For more information, refer to the "Consistency Checks" in SQLSetDescField .
-
SQLGetDescField
The SQL_DESC_TYPE and SQL_DESC_DATETIME_INTERVAL_CODE fields do not form a valid ODBC SQL type, a valid ODBC driver-specific SQL type (for IPD s), or a valid ODBC C type (for APD s or ARD s).
-
SQLSetDescField
The SQL_DESC_TYPE and SQL_DESC_DATETIME_INTERVAL_CODE fields do not form a valid ODBC SQL type or a valid ODBC driver-specific SQL type (for IPD s) or a valid ODBC C type (for APD s or ARD s).
Descriptor information checked during a consistency check was not consistent. (Refer to "Consistency Check" in SQLSetDescRec .)
-
SQLSetDescRec
The Type field, or any other field associated with the SQL_DESC_TYPE field in the descriptor, was not valid or consistent. Descriptor information checked during a consistency check was not consistent.
|
HY024 |
Invalid attribute value |
-
SQLGetInfo
(Driver Manager.) The InfoType argument was SQL_DRIVER_HSTMT , and the value pointed to by InfoValuePtr was not a valid statement handle.
-
SQLSetConnectAttr
Given the specified Attribute value, an invalid value was specified in ValuePtr . (The Driver Manager returns this SQLSTATE only for connection and statement attributes that accept a discrete set of values, such as SQL_ATTR_ACCESS_MODE or SQL_ATTR_ASYNC_ENABLE . For all other connection and statement attributes, the ODBC driver must verify the value specified in ValuePtr .)
The Attribute argument was SQL_ATTR_TRACEFILE or SQL_ATTR_TRANSLATE_LIB , and ValuePtr was an empty string.
-
SQLSetEnvAttr
Given the specified Attribute value, an invalid value was specified in ValuePtr .
-
SQLSetStmtAttr
Given the specified Attribute value, an invalid value was specified in ValuePtr . (The Driver Manager returns this SQLSTATE only for connection and statement attributes that accept a discrete set of values, such as SQL_ATTR_ACCESS_MODE or SQL_ATTR_ASYNC_ENABLE . For all other connection and statement attributes, the ODBC driver must verify the value specified in ValuePtr .)
The Attribute argument was SQL_ATTR_APP_ROW_DESC or SQL_ATTR_APP_PARAM_DESC , and ValuePtr was an explicitly allocated descriptor handle that is not on the same connection as the StatementHandle argument.
|
HY090 |
Invalid string or buffer length |
-
SQLBindCol
(Driver Manager.) The value specified for the argument BufferLength was less than 0.
(Driver Manager.) The ODBC driver was an ODBC 2.x driver, the ColumnNumber argument was set to 0, and the value specified for the argument BufferLength was not equal to 4.
-
SQLBindParameter
(Driver Manager.) The value in BufferLength was less than 0. (Refer to the description of the SQL_DESC_DATA_PTR field in SQLSetDescField .)
-
SQLBrowseConnect
(Driver Manager.) The value specified for argument StringLength1 was less than 0 and was not equal to SQL_NTS .
(Driver Manager.) The value specified for argument BufferLength was less than 0.
-
SQLBulkOperations
The Operation argument was SQL_ADD or SQL_UPDATE_BY_BOOKMARK ; a data value was not a null pointer; the C data type was SQL_C_BINARY or SQL_C_CHAR ; and the column length value was less than 0, but not equal to SQL_DATA_AT_EXEC , SQL_COLUMN_IGNORE , SQL_NTS , or SQL_NULL_DATA , or less than or equal to SQL_LEN_DATA_AT_EXEC_OFFSET .
The value in a length/indicator buffer was SQL_DATA_AT_EXEC ; the SQL type was either SQL_LONGVARCHAR , SQL_LONGVARBINARY , or a long data source-specific data type; and the SQL_NEED_LONG_DATA_LEN information type in SQLGetInfo was "Y".
The Operation argument was SQL_ADD , the SQL_ATTR_USE_BOOKMARK statement attribute was set to SQL_UB_VARIABLE , and column 0 was bound to a buffer whose length was not equal to the maximum length for the bookmark for this result set. (This length is available in the SQL_DESC_OCTET_LENGTH field of the IRD and can be obtained by calling SQLDescribeCol , SQLColAttribute , or SQLGetDescField .)
-
SQLColAttribute
(Driver Manager.) *CharacterAttributePtr is a character string, and BufferLength was less than 0 but not equal to SQL_NTS .
-
SQLColumnPrivileges
(Driver Manager.) The value of one of the name length arguments was less than 0 but not equal to SQL_NTS .
The value of one of the name length arguments exceeded the maximum length value for the corresponding name.
-
SQLColumns
(Driver Manager.) The value of one of the name length arguments was less than 0 but not equal to SQL_NTS .
The value of one of the name length arguments exceeded the maximum length value for the corresponding catalog or name. The maximum length of each catalog or name may be obtained by calling SQLGetInfo with the InfoType values.
-
SQLConnect
(Driver Manager.) The value specified for argument NameLength1 , NameLength2 , or NameLength3 was less than 0 but not equal to SQL_NTS .
(Driver Manager.) The value specified for argument NameLength1 exceeded the maximum length for a data source name.
-
SQLDataSources
(Driver Manager.) The value specified for argument BufferLength1 was less than 0.
(Driver Manager.) The value specified for argument BufferLength2 was less than 0.
-
SQLDescribeCol
(Driver Manager.) The value specified for argument BufferLength was less than 0.
-
SQLDriverConnect
(Driver Manager.) The value specified for argument StringLength1 was less than 0 and was not equal to SQL_NTS .
(Driver Manager.) The value specified for argument BufferLength was less than 0.
-
SQLDrivers
(Driver Manager.) The value specified for argument BufferLength1 was less than 0.
(Driver Manager.) The value specified for argument BufferLength2 was less than 0 or equal to 1.
- SQLExecDirect
(Driver Manager.) The argument TextLength was less than or equal to 0 but not equal to SQL_NTS .
A parameter value, set with SQLBindParameter , was a null pointer, and the parameter length value was not 0, SQL_NULL_DATA , SQL_DATA_AT_EXEC , SQL_DEFAULT_PARAM , or less than or equal to SQL_LEN_DATA_AT_EXEC_OFFSET .
A parameter value, set with SQLBindParameter , was not a null pointer; the C data type was SQL_C_BINARY or SQL_C_CHAR ; and the parameter length value was less than 0 but was not SQL_NTS , SQL_NULL_DATA , SQL_DATA_AT_EXEC , SQL_DEFAULT_PARAM , or less than or equal to SQL_LEN_DATA_AT_EXEC_OFFSET .
A parameter length value bound by SQLBindParameter was set to SQL_DATA_AT_EXEC ; the SQL type was either SQL_LONGVARCHAR , SQL_LONGVARBINARY , or a long data source-specific data type; and the SQL_NEED_LONG_DATA_LEN information type in SQLGetInfo was "Y".
- SQLExecute
A parameter value, set with SQLBindParameter , was a null pointer, and the parameter length value was not 0, SQL_NULL_DATA , SQL_DATA_AT_EXEC , SQL_DEFAULT_PARAM , or less than or equal to SQL_LEN_DATA_AT_EXEC_OFFSET .
A parameter value, set with SQLBindParameter , was not a null pointer; the C data type was SQL_C_BINARY or SQL_C_CHAR ; and the parameter length value was less than 0 but was not SQL_NTS , SQL_NULL_DATA , SQL_DEFAULT_PARAM , or SQL_DATA_AT_EXEC , or less than or equal to SQL_LEN_DATA_AT_EXEC_OFFSET .
A parameter length value bound by SQLBindParameter was set to SQL_DATA_AT_EXEC ; the SQL type was either SQL_LONGVARCHAR , SQL_LONGVARBINARY , or a long data source-specific data type; and the SQL_NEED_LONG_DATA_LEN information type in SQLGetInfo was "Y".
-
SQLFetch
The SQL_ATTR_USE_BOOKMARK statement attribute was set to SQL_UB_VARIABLE , and column 0 was bound to a buffer whose length was not equal to the maximum length for the bookmark for this result set. (This length is available in the SQL_DESC_OCTET_LENGTH field of the IRD and can be obtained by calling SQLDescribeCol , SQLColAttribute , or SQLGetDescField .)
-
SQLFetchScroll
The SQL_ATTR_USE_BOOKMARK statement attribute was set to SQL_UB_VARIABLE , and column 0 was bound to a buffer whose length was not equal to the maximum length for the bookmark for this result set. (This length is available in the SQL_DESC_OCTET_LENGTH field of the IRD and can be obtained by calling SQLDescribeCol , SQLColAttribute , or SQLGetDescField .)
-
SQLForeignKeys
(Driver Manager.) The value of one of the name length arguments was less than 0 but not equal to SQL_NTS .
The value of one of the name length arguments exceeded the maximum length value for the corresponding name.
-
SQLGetConnectAttr
(Driver Manager.) *ValuePtr is a character string, and BufferLength was less than zero but not equal to SQL_NTS .
-
SQLGetCursorName
(Driver Manager.) The value specified in the argument BufferLength was less than 0.
-
SQLGetData
(Driver Manager.) The value specified for argument BufferLength was less than 0.
The value specified for argument BufferLength was less than 4, the ColumnNumber argument was set to 0, and the ODBC driver was an ODBC 2.x driver.
-
SQLGetDescField
(Driver Manager.) *ValuePtr was a character string, and BufferLength was less than zero.
-
SQLGetInfo
(Driver Manager.) The value specified for argument BufferLength was less than 0.
(Driver Manager.) The value specified for BufferLength was an odd number, and *InfoValuePtr was of a Unicode data type.
-
SQLGetStmtAttr
(Driver Manager.) *ValuePtr is a character string, and BufferLength was less than zero, but not equal to SQL_NTS .
-
SQLNativeSql
(Driver Manager.) The argument TextLength1 was less than 0, but not equal to SQL_NTS .
(Driver Manager.) The argument BufferLength was less than 0 and the argument OutStatementText was not a null pointer.
SQLParamData
-
SQLPrepare
(Driver Manager.) The argument TextLength was less than or equal to 0 but not equal to SQL_NTS .
-
SQLPrimaryKeys
(Driver Manager.) The value of one of the name length arguments was less than 0 but not equal to SQL_NTS , and the associated name argument is not a null pointer.
The value of one of the name length arguments exceeded the maximum length value for the corresponding name.
-
SQLProcedureColumns
(Driver Manager.) The value of one of the name length arguments was less than 0 but not equal to SQL_NTS .
The value of one of the name length arguments exceeded the maximum length value for the corresponding catalog, schema, procedure, or column name.
-
SQLProcedures
(Driver Manager.) The value of one of the name length arguments was less than 0 but not equal to SQL_NTS .
The value of one of the name length arguments exceeded the maximum length value for the corresponding name.
-
SQLPutData
The argument DataPtr was not a null pointer, and the argument StrLen_or_Ind was less than 0 but not equal to SQL_NTS or SQL_NULL_DATA .
-
SQLSetConnectAttr
(Driver Manager.) *ValuePtr is a character string, and the StringLength argument was less than 0 but was not SQL_NTS .
-
SQLSetCursorName
(Driver Manager.) The argument NameLength was less than 0 but not equal to SQL_NTS .
-
SQLSetDescField
(Driver Manager.) *ValuePtr is a character string, and BufferLength was less than zero but was not equal to SQL_NTS .
(Driver Manager.) The ODBC driver was an ODBC 2.x driver, the descriptor was an ARD , the ColumnNumber argument was set to 0, and the value specified for the argument BufferLength was not equal to 4.
-
SQLSetDescRec
(Driver Manager.) The ODBC driver was an ODBC 2.x driver, the descriptor was an ARD , the ColumnNumber argument was set to 0, and the value specified for the argument BufferLength was not equal to 4.
-
SQLSetEnvAttr
The StringLength argument was less than 0 but was not SQL_NTS .
-
SQLSetPos
The Operation argument was SQL_UPDATE , a data value was a null pointer, and the column length value was not 0, SQL_DATA_AT_EXEC , SQL_COLUMN_IGNORE , SQL_NULL_DATA , or less than or equal to SQL_LEN_DATA_AT_EXEC_OFFSET .
The Operation argument was SQL_UPDATE ; a data value was not a null pointer; the C data type was SQL_C_BINARY or SQL_C_CHAR ; and the column length value was less than 0 but not equal to SQL_DATA_AT_EXEC , SQL_COLUMN_IGNORE , SQL_NTS , or SQL_NULL_DATA , or less than or equal to SQL_LEN_DATA_AT_EXEC_OFFSET .
The value in a length/indicator buffer was SQL_DATA_AT_EXEC ; the SQL type was either SQL_LONGVARCHAR , SQL_LONGVARBINARY , or a long data source-specific data type; and the SQL_NEED_LONG_DATA_LEN information type in SQLGetInfo was "Y".
-
SQLSetStmtAttr
(Driver Manager.) *ValuePtr is a character string, and the StringLength argument was less than 0 but was not SQL_NTS .
-
SQLSpecialColumns
(Driver Manager.) The value of one of the length arguments was less than 0 but not equal to SQL_NTS .
The value of one of the length arguments exceeded the maximum length value for the corresponding name. The maximum length of each name can be obtained by calling SQLGetInfo with the InfoType values: SQL_MAX_CATALOG_NAME_LEN , SQL_MAX_SCHEMA_NAME_LEN , or SQL_MAX_TABLE_NAME_LEN .
-
SQLStatistics
(Driver Manager.) The value of one of the name length arguments was less than 0 but not equal to SQL_NTS .
The value of one of the name length arguments exceeded the maximum length value for the corresponding name.
-
SQLTablePrivileges
(Driver Manager.) The value of one of the name length arguments was less than 0 but not equal to SQL_NTS .
The value of one of the name length arguments exceeded the maximum length value for the corresponding qualifier or name.
-
SQLTables
(Driver Manager.) The value of one of the length arguments was less than 0 but not equal to SQL_NTS .
The value of one of the name length arguments exceeded the maximum length value for the corresponding name.
|
HY091 |
Invalid descriptor field identifier |
-
SQLColAttribute
The value specified for the argument FieldIdentifier was not one of the defined values and was not an implementation-defined value.
-
SQLGetDescField
FieldIdentifier was not an ODBC-defined field and was not an implementation-defined value.
FieldIdentifier was undefined for the DescriptorHandle .
-
SQLSetDescField
The value specified for the FieldIdentifier argument was not an ODBC-defined field and was not an implementation-defined value.
The FieldIdentifier argument was invalid for the DescriptorHandle argument.
The FieldIdentifier argument was a read-only, ODBC-defined field.
|
HY092 |
Invalid attribute/option identifier |
-
SQLAllocHandle
(Driver Manager.) The HandleType argument was not: SQL_HANDLE_ENV , SQL_HANDLE_DBC , SQL_HANDLE_STMT , or SQL_HANDLE_DESC .
-
SQLBulkOperations
(Driver Manager.) The value specified for the Operation argument was invalid.
The Operation argument was SQL_ADD , SQL_UPDATE_BY_BOOKMARK , or SQL_DELETE_BY_BOOKMARK , and the SQL_ATTR_CONCURRENCY statement attribute was set to SQL_CONCUR_READ_ONLY .
The Operation argument was SQL_DELETE_BY_BOOKMARK , SQL_FETCH_BY_BOOKMARK , or SQL_UPDATE_BY_BOOKMARK , and the bookmark column was not bound or the SQL_ATTR_USE_BOOKMARKS statement attribute was set to SQL_UB_OFF .
-
SQLCopyDesc
The call to SQLCopyDesc prompted a call to SQLSetDescField , but *ValuePtr was not valid for the FieldIdentifier argument on TargetDescHandle .
-
SQLDriverConnect
(Driver Manager.) The DriverCompletion argument was SQL_DRIVER_PROMPT , and the WindowHandle argument was a null pointer.
-
SQLEndTran
(Driver Manager.) The value specified for the argument HandleType was neither SQL_HANDLE_ENV nor SQL_HANDLE_DBC .
-
SQLFreeStmt
(Driver Manager.) The value specified for the argument Option was not:
SQL_CLOSE
SQL_DROP
SQL_UNBIND
SQL_RESET_PARAMS
-
SQLGetConnectAttr , SQLGetEnvAttr , SQLGetStmtAttr
The value specified for the argument Attribute was not valid for the version of ODBC supported by the ODBC driver.
SQLParamData
-
SQLSetConnectAttr
(Driver Manager.) The value specified for the argument Attribute was not valid for the version of ODBC supported by the ODBC driver.
(Driver Manager.) The value specified for the argument Attribute was a read-only attribute.
-
SQLSetDescField
The value in *ValuePtr was not valid for the FieldIdentifier argument.
The FieldIdentifier argument was SQL_DESC_UNNAMED , and ValuePtr was SQL_NAMED .
-
SQLSetEnvAttr
(Driver Manager.) The value specified for the argument Attribute was not valid for the version of ODBC supported by the ODBC driver.
-
SQLSetPos
(Driver Manager.) The value specified for the Operation argument was invalid.
(Driver Manager.) The value specified for the LockType argument was invalid.
The Operation argument was SQL_UPDATE or SQL_DELETE , and the SQL_ATTR_CONCURRENCY statement attribute was SQL_ATTR_CONCUR_READ_ONLY .
-
SQLSetStmtAttr
(Driver Manager.) The value specified for the argument Attribute was not valid for the version of ODBC supported by the ODBC driver.
(Driver Manager.) The value specified for the argument Attribute was a read-only attribute.
|
HY095 |
Function type out of range |
|
HY096 |
Invalid information type |
|
HY097 |
Column type out of range |
|
HY098 |
Scope type out of range |
|
HY099 |
Nullable type out of range |
|
HY100 |
Uniqueness option type out of range |
|
HY101 |
Accuracy option type out of range |
|
HY103 |
Invalid retrieval code |
-
SQLDataSources
(Driver Manager.) The value specified for the argument Direction was not equal to SQL_FETCH_FIRST , SQL_FETCH_FIRST_USER , SQL_FETCH_FIRST_SYSTEM , or SQL_FETCH_NEXT .
-
SQLDrivers
(Driver Manager.) The value specified for the argument Direction was not equal to SQL_FETCH_FIRST or SQL_FETCH_NEXT .
|
HY104 |
Invalid precision or scale value |
|
HY105 |
Invalid parameter type |
-
SQLBindParameter
(Driver Manager.) The value specified for the argument InputOutputType was invalid.
- SQLExecDirect,
SQLExecute
The value specified for the argument InputOutputType in
SQLBindParameter was SQL_PARAM_OUTPUT , and the parameter was an input parameter.
SQLParamData
-
SQLSetDescField
(Driver Manager.) The value specified for the SQL_DESC_PARAMETER_TYPE field was invalid. (For more information, refer to the "InputOutputType Argument" section in SQLBindParameter .)
|
HY106 |
Fetch type out of range |
-
SQLExtendedFetch
(Driver Manager.) The value specified for the argument FetchOrientation was invalid.
The argument FetchOrientation was SQL_FETCH_BOOKMARK , and the SQL_ATTR_USE_BOOKMARKS statement attribute was set to SQL_UB_OFF .
The value of the SQL_CURSOR_TYPE statement option was SQL_CURSOR_FORWARD_ONLY , and the value of argument FetchOrientation was not SQL_FETCH_NEXT .
The argument FetchOrientation was SQL_FETCH_RESUME .
-
SQLFetchScroll
(Driver Manager.) The value specified for the argument FetchOrientation was invalid.
(Driver Manager.) The argument FetchOrientation was SQL_FETCH_BOOKMARK , and the SQL_ATTR_USE_BOOKMARKS statement attribute was set to SQL_UB_OFF .
The value of the SQL_ATTR_CURSOR_TYPE statement attribute was SQL_CURSOR_FORWARD_ONLY , and the value of argument FetchOrientation was not SQL_FETCH_NEXT .
The value of the SQL_ATTR_CURSOR_SCROLLABLE statement attribute was SQL_NONSCROLLABLE , and the value of argument FetchOrientation was not SQL_FETCH_NEXT .
|
HY107 |
Row value out of range |
-
SQLExtendedFetch
The value specified with the SQL_CURSOR_TYPE statement option was SQL_CURSOR_KEYSET_DRIVEN , but the value specified with the SQL_KEYSET_SIZE statement attribute was greater than 0 and less than the value specified with the SQL_ROWSET_SIZE statement attribute.
-
SQLFetch , SQLFetchScroll
The value specified with the SQL_ATTR_CURSOR_TYPE statement attribute was SQL_CURSOR_KEYSET_DRIVEN , but the value specified with the SQL_ATTR_KEYSET_SIZE statement attribute was greater than 0 and less than the value specified with the SQL_ATTR_ROW_ARRAY_SIZE statement attribute.
-
SQLSetPos
The value specified for the argument RowNumber was greater than the number of rows in the rowset.
|
HY109 |
Invalid cursor position |
SQLExecDirect
*StatementText contained a positioned update or delete statement, and the cursor was positioned (by SQLSetPos or SQLFetchScroll ) on a row that had been deleted or could not be fetched.
SQLExecute
The prepared statement was a positioned update or delete statement, and the cursor was positioned (by SQLSetPos or SQLFetchScroll ) on a row that had been deleted or could not be fetched.
-
SQLGetData
The cursor was positioned (by SQLSetPos , SQLFetch , SQLFetchScroll , or SQLBulkOperations ) on a row that had been deleted or could not be fetched.
The cursor was a forward-only cursor, and the rowset size was greater than one.
-
SQLGetStmtAttr
The Attribute argument was SQL_ATTR_ROW_NUMBER and the row had been deleted or could not be fetched.
-
SQLNativeSql
The current row of the cursor had been deleted or had not been fetched. This error may not be returned by a ODBC driver having a native DBMS cursor implementation.
SQLParamData
- SQLSetPos
The cursor associated with the StatementHandle was defined as forward-only, so the cursor could not be positioned within the rowset. See the description for the SQL_ATTR_CURSOR_TYPE attribute in SQLSetStmtAttr .
The Operation argument was SQL_UPDATE , SQL_DELETE , or SQL_REFRESH , and the row identified by the RowNumber argument had been deleted or had not been fetched.
(Driver Manager.) The RowNumber argument was 0, and the Operation argument was SQL_POSITION .
SQLSetPos was called after SQLBulkOperations was called and before SQLFetchScroll or SQLFetch was called.
|
HY110 |
Invalid driver completion |
-
SQLDriverConnect
(Driver Manager.) The value specified for the argument DriverCompletion was not equal to SQL_DRIVER_PROMPT , SQL_DRIVER_COMPLETE , SQL_DRIVER_COMPLETE_REQUIRED , or SQL_DRIVER_NOPROMPT .
(Driver Manager.) Connection pooling was enabled, and the value specified for the argument DriverCompletion was not equal to SQL_DRIVER_NOPROMPT .
|
HY111 |
Invalid bookmark value |
-
SQLExtendedFetch
The argument FetchOrientation was SQL_FETCH_BOOKMARK , and the bookmark specified in the FetchOffset argument was not valid.
SQLFetchScroll
The argument FetchOrientation was SQL_FETCH_BOOKMARK , and the bookmark pointed to by the value in the SQL_ATTR_FETCH_BOOKMARK_PTR statement attribute was not valid or was a null pointer.
|
HYC00 |
Optional feature not implemented |
-
SQLAllocHandle
The HandleType argument was SQL_HANDLE_DESC and the ODBC driver was an ODBC 2.x driver.
-
SQLBindCol , SQLBindParameter
The ODBC driver or data source does not support the conversion specified by the combination of the TargetType argument and the driver-specific SQL data type of the corresponding column.
The argument ColumnNumber was 0 and the ODBC driver does not support bookmarks.
The ODBC driver supports only ODBC 2.x and the argument TargetType was one of the following:
SQL_C_GUID
SQL_C_NUMERIC
SQL_C_SBIGINT
SQL_C_UBIGINT
and any of the interval C data types listed in Data Types in Appendix D: Data Types.
- SQLBulkOperations
The ODBC driver or data source does not support the operation requested in the Operation argument.
-
SQLColAttribute
The value specified for the argument FieldIdentifier was not supported by the ODBC driver.
-
SQLColumnPrivileges
A catalog name was specified, and the ODBC driver or data source does not support catalogs.
A schema name was specified, and the ODBC driver or data source does not support schemas.
A string search pattern was specified for the column name, and the data source does not support search patterns for that argument.
The combination of the current settings of the SQL_CONCURRENCY and SQL_CURSOR_TYPE statement attributes was not supported by the ODBC driver or data source.
The SQL_ATTR_USE_BOOKMARKS statement attribute was set to SQL_UB_VARIABLE , and the SQL_ATTR_CURSOR_TYPE statement attribute was set to a cursor type for which the ODBC driver does not support bookmarks.
-
SQLColumns
A catalog name was specified, and the ODBC driver or data source does not support catalogs.
A schema name was specified, and the ODBC driver or data source does not support schemas.
A string search pattern was specified for the schema name, table name, or column name, and the data source does not support search patterns for one or more of those arguments.
The combination of the current settings of the SQL_ATTR_CONCURRENCY and SQL_ATTR_CURSOR_TYPE statement attributes was not supported by the ODBC driver or data source.
The SQL_ATTR_USE_BOOKMARKS statement attribute was set to SQL_UB_VARIABLE , and the SQL_ATTR_CURSOR_TYPE statement attribute was set to a cursor type for which the ODBC driver does not support bookmarks.
-
SQLDriverConnect
The ODBC driver does not support the version of ODBC behaviour that the application requested.
-
SQLEndTran
The ODBC driver or data source does not support the ROLLBACK operation.
- SQLExecDirect,
SQLExecute
The combination of the current settings of the SQL_ATTR_CONCURRENCY and SQL_ATTR_CURSOR_TYPE statement attributes was not supported by the ODBC driver or data source.
The SQL_ATTR_USE_BOOKMARKS statement attribute was set to SQL_UB_VARIABLE , and the SQL_ATTR_CURSOR_TYPE statement attribute was set to a cursor type for which the ODBC driver does not support bookmarks.
-
SQLExtendedFetch
Driver or data source does not support the specified fetch type.
The ODBC driver or data source does not support the conversion specified by the combination of the TargetType in SQLBindCol and the SQL data type of the corresponding column. This error applies only when the SQL data type of the column was mapped to a ODBC driver-specific SQL data type.
-
SQLFetch
The ODBC driver or data source does not support the conversion specified by the combination of the TargetType in SQLBindCol and the SQL data type of the corresponding column.
SQLFetchScroll
Driver or data source does not support the specified fetch type.
The ODBC driver or data source does not support the conversion specified by the combination of the TargetType in SQLBindCol and the SQL data type of the corresponding column.
FetchOrientation was SQL_FETCH_BOOKMARK , FetchOffset was not equal to 0, and the underlying ODBC driver is an ODBC 2.x driver.
-
SQLForeignKeys
A catalog name was specified, and the ODBC driver or data source does not support catalogs.
A schema name was specified, and the ODBC driver or data source does not support schemas.
The combination of the current settings of the SQL_ATTR_CONCURRENCY and SQL_ATTR_CURSOR_TYPE statement attributes was not supported by the ODBC driver or data source.
The SQL_ATTR_USE_BOOKMARKS statement attribute was set to SQL_UB_VARIABLE , and the SQL_ATTR_CURSOR_TYPE statement attribute was set to a cursor type for which the ODBC driver does not support bookmarks.
-
SQLGetConnectAttr
The value specified for the argument Attribute was a valid ODBC connection attribute for the version of ODBC supported by the ODBC driver, but was not supported by the driver.
-
SQLGetData
The ODBC driver or data source does not support use of SQLGetData with multiple rows in SQLFetchScroll . This description does not apply to ODBC drivers that return the SQL_GD_BLOCK bitmask for the SQL_GETDATA_EXTENSIONS option in SQLGetInfo .
The ODBC driver or data source does not support the conversion specified by the combination of the TargetType argument and the SQL data type of the corresponding column. This error applies only when the SQL data type of the column was mapped to a driver-specific SQL data type.
The ODBC driver supports only ODBC 2.x , and the argument TargetType was one of the following:
SQL_C_GUID
SQL_C_NUMERIC
SQL_C_SBIGINT
SQL_C_UBIGINT
and any of the interval C data types listed in C Data Types.
SQLGetEnvAttr
-
SQLGetInfo
The value specified for the argument InfoType was a driver-specific value that is not supported by the ODBC driver.
-
SQLGetStmtAttr
The value specified for the argument Attribute was a valid ODBC statement attribute for the version of ODBC supported by the ODBC driver, but was not supported by the driver.
-
SQLGetTypeInfo
The combination of the current settings of the SQL_ATTR_CONCURRENCY and SQL_ATTR_CURSOR_TYPE statement attributes was not supported by the ODBC driver or data source.
The SQL_ATTR_USE_BOOKMARKS statement attribute was set to SQL_UB_VARIABLE , and the SQL_ATTR_CURSOR_TYPE statement attribute was set to a cursor type for which the ODBC driver does not support bookmarks.
SQLParamData
-
SQLPrepare
The concurrency setting was invalid for the type of cursor defined.
The SQL_ATTR_USE_BOOKMARKS statement attribute was set to SQL_UB_VARIABLE , and the SQL_ATTR_CURSOR_TYPE statement attribute was set to a cursor type for which the ODBC driver does not support bookmarks.
-
SQLPrimaryKeys
A catalog was specified, and the ODBC driver or data source does not support catalogs.
A schema was specified and the ODBC driver or data source does not support schemas.
The combination of the current settings of the SQL_ATTR_CONCURRENCY and SQL_ATTR_CURSOR_TYPE statement attributes was not supported by the ODBC driver or data source.
The SQL_ATTR_USE_BOOKMARKS statement attribute was set to SQL_UB_VARIABLE , and the SQL_ATTR_CURSOR_TYPE statement attribute was set to a cursor type for which the ODBC driver does not support bookmarks.
-
SQLProcedureColumns , SQLProcedures
A procedure catalog was specified, and the ODBC driver or data source does not support catalogs.
A procedure schema was specified, and the ODBC driver or data source does not support schemas.
A string search pattern was specified for the procedure schema, procedure name, or column name, and the data source does not support search patterns for one or more of those arguments.
The combination of the current settings of the SQL_ATTR_CONCURRENCY and SQL_ATTR_CURSOR_TYPE statement attributes was not supported by the ODBC driver or data source.
The SQL_ATTR_USE_BOOKMARKS statement attribute was set to SQL_UB_VARIABLE , and the SQL_ATTR_CURSOR_TYPE statement attribute was set to a cursor type for which the ODBC driver does not support bookmarks.
-
SQLSetConnectAttr
The value specified for the argument Attribute was a valid ODBC connection or statement attribute for the version of ODBC supported by the ODBC driver but was not supported by the ODBC driver.
-
SQLSetEnvAttr
The value specified for the argument Attribute was a valid ODBC environment attribute for the version of ODBC supported by the ODBC driver, but was not supported by the driver.
(Driver Manager.) The Attribute argument was SQL_ATTR_OUTPUT_NTS , and ValuePtr was SQL_FALSE .
- SQLSetPos
The ODBC driver or data source does not support the operation requested in the Operation argument or the LockType argument.
-
SQLSetStmtAttr
The value specified for the argument Attribute was a valid ODBC statement attribute for the version of ODBC supported by the ODBC driver but was not supported by the driver.
The Attribute argument was SQL_ATTR_ASYNC_ENABLE , and a call to SQLGetInfo with an InfoType of SQL_ASYNC_MODE returns SQL_AM_CONNECTION .
The Attribute argument was SQL_ATTR_ENABLE_AUTO_IPD , and the value of the connection attribute SQL_ATTR_AUTO_IPD was SQL_FALSE .
-
SQLSpecialColumns , SQLStatistics
A catalog was specified, and the ODBC driver or data source does not support catalogs.
A schema was specified, and the ODBC driver or data source does not support schemas.
The combination of the current settings of the SQL_ATTR_CONCURRENCY and SQL_ATTR_CURSOR_TYPE statement attributes was not supported by the ODBC driver or data source.
The SQL_ATTR_USE_BOOKMARKS statement attribute was set to SQL_UB_VARIABLE , and the SQL_ATTR_CURSOR_TYPE statement attribute was set to a cursor type for which the ODBC driver does not support bookmarks.
-
SQLTablePrivileges , SQLTables
A catalog was specified, and the ODBC driver or data source does not support catalogs.
A schema was specified, and the ODBC driver or data source does not support schemas.
A string search pattern was specified for the table schema, table name, or column name, and the data source does not support search patterns for one or more of those arguments.
The combination of the current settings of the SQL_ATTR_CONCURRENCY and SQL_ATTR_CURSOR_TYPE statement attributes was not supported by the ODBC driver or data source.
The SQL_ATTR_USE_BOOKMARKS statement attribute was set to SQL_UB_VARIABLE , and the SQL_ATTR_CURSOR_TYPE statement attribute was set to a cursor type for which the ODBC driver does not support bookmarks.
|
HYT00 |
Timeout expired |
-
SQLBrowseConnect
The login timeout period expired before the connection to the data source completed. The timeout period is set through SQLSetConnectAttr ,
SQL_ATTR_LOGIN_TIMEOUT .
SQLBulkOperations
The query timeout period expired before the data source returned the result set. The timeout period is set through SQLSetStmtAttr with an Attribute argument of SQL_ATTR_QUERY_TIMEOUT .
-
SQLColumnPrivileges , SQLColumns ,SQLExecDirect ,SQLExecute , SQLForeignKeys , SQLGetTypeInfo
The query timeout period expired before the data source returned the result set. The timeout period is set through SQLSetStmtAttr , SQL_ATTR_QUERY_TIMEOUT .
-
SQLConnect
The query timeout period expired before the connection to the data source completed. The timeout period is set through SQLSetConnectAttr , SQL_ATTR_LOGIN_TIMEOUT .
-
SQLDriverConnect
The login timeout period expired before the connection to the data source completed. The timeout period is set through SQLSetConnectAttr , SQL_ATTR_LOGIN_TIMEOUT .
-
SQLExtendedFetch , SQLTablePrivileges
The query timeout period expired before the data source returned the result set. The timeout period is set through SQLSetStmtOption , SQL_QUERY_TIMEOUT .
SQLParamData
-
SQLPrepare , SQLProcedureColumns
The timeout period expired before the data source returned the result set. The timeout period is set through SQLSetStmtAttr , SQL_ATTR_QUERY_TIMEOUT .
-
SQLPrimaryKeys
The timeout period expired before the data source returned the requested result set. The timeout period is set through SQLSetStmtAttr , SQL_ATTR_QUERY_TIMEOUT .
-
SQLProcedures , SQLSpecialColumns , SQLStatistics , SQLTables
The query timeout period expired before the data source returned the requested result set. The timeout period is set through SQLSetStmtAttr , SQL_ATTR_QUERY_TIMEOUT .
SQLSetPos
The query timeout period expired before the data source returned the result set. The timeout period is set through SQLSetStmtAttr with an Attribute of SQL_ATTR_QUERY_TIMEOUT .
|
HYT01 |
Connection timeout expired |
|