Chapter 4. tbCLI Error Messages

Table of Contents

4.1. Return Codes
4.2. SQLSTATE
4.2.1. 01000 ~01007
4.2.2. 01S00 ~ 01S09
4.2.3. 07001 ~ 07009
4.2.4. 07S01
4.2.5. 08001 ~ 08007
4.2.6. 08S01
4.2.7. 21S01 ~ 21S02
4.2.8. 22001 ~ 22026
4.2.9. 23000, 24000, 25000
4.2.10. 25S01 ~ 25S03
4.2.11. 28000, 34000
4.2.12. 3C000 ~ 3F000
4.2.13. 40001 ~ 40003, 42000
4.2.14. 42S01 ~ 42S22, 44000
4.2.15. HY000 ~ HY024
4.2.16. HY090 ~ HY111
4.2.17. HYC00
4.2.18. HYT00 ~ HYT01
4.2.19. IM001 ~ IM015
4.2.20. 00000, 02000

This chapter describes errors that might occur while the tbCLI program is executed.

4.1. Return Codes

All tbCLI functions return a return code after execution. The return code is SQLRETURN type and an already defined value.

A tbCLI program state can be checked according to the return code returned by a tbCLI function as follows.

Return codeDescription
SQL_SUCCESSFunction finished successfully.
SQL_SUCCESS_WITH_INFOFunction finished successfully, but there is a warning message.
SQL_NO_DATA

Function finished successfully, but related data cannot be found.

(Ex: No row is updated by the given SQL statement)

SQL_INVALID_HANDLE

The handle given to an input parameter is invalid.

SQL_NEED_DATA

More data is required to execute the SQL statement

(Ex: Parameter)

SQL_STILL_EXECUTINGPreviously executed SQL statement has not finished.
SQL_ERRORCritical error has occurred.

These return codes can have additional SQLSTATE information.

Note

Refer to “4.2. SQLSTATE” for more information on SQLSTATE or related APIs.

4.2. SQLSTATE

This section enumerates SQLSTATE information in the code order, and describes it. In addition, this section also describes the functions that can return the SQLSTATE code.

4.2.1. 01000 ~01007

  • 01000

    DescriptionGeneral warning.
    Function

    All functions except for SQLError, SQLGetDiagField, and SQLGetDiagRec.

  • 01001

    DescriptionOccurs when there is a cursor operation conflict.
    FunctionSQLExecDirec, SQLExecute, SQLParamDat, SQLSetPos
  • 01002

    DescriptionOccurs while disconnecting a database connection.
    FunctionSQLError, SQLGetDiagField, SQLGetDiagRec
  • 01003

    DescriptionOccurs when NULL value is deleted from the specified function.
    FunctionSQLExecDirect, SQLExecute, SQLParamData
  • 01004

    DescriptionOccurs when string data is truncated from the right.
    Function

    SQLBrowseConnect, SQLBulkOperations, SQLColAttribute, SQLDataSources,

    SQLDescribeCol, SQLDriverConnect, SQLDrivers, SQLExecDirect, SQLExecute,

    SQLExtendedFetch, SQLFetch, SQLFetchScroll, SQLGetConnectAttr, SQLGetCursorName,

    SQLGetData, SQLGetDescField, SQLGetDescRec, SQLGetEnvAttr, SQLGetInfo,

    SQLGetStmtAttr, SQLNativeSql, SQLParamData, SQLPutData, SQLSetCursorName

  • 01006

    DescriptionOccurs when the privilege is not canceled.
    FunctionSQLExecDirec, SQLExecute, SQLParamData
  • 01007

    DescriptionOccurs when the privilege is not granted.
    FunctionSQLExecDirect, SQLExecute, SQLParamData

4.2.2. 01S00 ~ 01S09

  • 01S00

    DescriptionOccurs when the character string property is not valid.
    FunctionSQLBrowseConnect, SQLDriverConnect
  • 01S01

    DescriptionError in a row.
    FunctionSQLBulkOperations, SQLExtendedFetch, SQLSetPos
  • 01S02

    DescriptionOccurs when an option value is changed.
    Function

    All functions excluding the following functions:

    SQLBrowseConnect, SQLConnect, SQLDriverConnect, SQLExecDirect, SQLExecute,

    SQLParamData, SQLPrepare, SQLSetConnectAttr, SQLSetDescField, SQLSetEnvAttr,

    SQLSetStmtAttr

  • 01S06

    DescriptionOccurs when a fetch is attempted before the first row of the result set is returned.
    FunctionSQLExtendedFetch, SQLFetchScroll
  • 01S07

    DescriptionOccurs when part of a numeric type or DATETIME type is truncated.
    Function

    SQLBulkOperations, SQLExecDirect, SQLExecute, SQLExtendedFetch, SQLFetch,

    SQLFetchScroll, SQLGetData, SQLParamData, SQLSetPos

  • 01S08

    DescriptionOccurs when DSN file (.dsn) cannot be saved.
    FunctionSQLDriverConnect.
  • 01S09

    DescriptionOccurs when the reserved word is invalid.
    FunctionSQLDriverConnect.

4.2.3. 07001 ~ 07009

  • 07001

    DescriptionOccurs when a parameter number is invalid.
    FunctionSQLExecDirect, SQLExecute
  • 07002

    DescriptionError on COUNT field.
    FunctionSQLExecDirect, SQLExecute, SQLParamData
  • 07005

    DescriptionOccurs when a prepared statement's cursor is out of range.
    FunctionSQLColAttribute, SQLDescribeCol
  • 07006

    DescriptionViolation of a limited data type property.
    Function

    SQLBindCol, SQLBindParameter, SQLBulkOperations, SQLExecDirect, SQLExecute,

    SQLExtendedFetch, SQLFetch, SQLFetchScroll, SQLGetData, SQLParamData,

    SQLPutData, SQLSetPos

  • 07009

    DescriptionInvalid descriptor index.
    Function

    SQLBindCol, SQLBindParameter, SQLBulkOperations, SQLColAttribute, SQLDescribeCol,

    SQLDescribeParam, SQLFetch, SQLFetchScroll, SQLGetData, SQLGetDescField,

    SQLGetDescRec, SQLParamData, SQLSetDescField, SQLSetDescRec, SQLSetPos

4.2.4. 07S01

  • 07S01

    DescriptionOccurs when a default parameter is incorrectly used.
    FunctionSQLExecDirect, SQLExecute, SQLParamData, SQLPutData

4.2.5. 08001 ~ 08007

  • 08001

    DescriptionOccurs when a client cannot connect to a datasource.
    FunctionSQLBrowseConnect, SQLConnect, SQLDriverConnect
  • 08002

    DescriptionOccurs when a database connection name is already in use.
    FunctionSQLBrowseConnect, SQLConnect, SQLDriverConnect, SQLSetConnectAttr
  • 08003

    DescriptionOccurs when a connection does not exist.
    Function

    SQLAllocHandle, SQLDisconnect, SQLEndTran, SQLGetConnectAttr, SQLGetInfo,

    SQLNativeSql, SQLSetConnectAttr

  • 08004

    DescriptionOccurs when the server denies a connection.
    FunctionSQLBrowseConnect, SQLConnect, SQLDriverConnect
  • 08007

    DescriptionOccurs when a connection fails, while executing a transaction.
    FunctionSQLEndTran

4.2.6. 08S01

  • 08S01

    DescriptionOccurs when a communication connection fails.
    Function

    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

4.2.7. 21S01 ~ 21S02

  • 21S01

    DescriptionOccurs when the list of values to be inserted does not match the columns.
    FunctionSQLExecDirect, SQLPrepare
  • 21S02

    DescriptionOccurs when a derived tables degree and columns do not match.
    Function

    SQLBulkOperations, SQLExecDirect, SQLExecute, SQLParamData, SQLPrepare,

    SQLSetPos

4.2.8. 22001 ~ 22026

  • 22001

    DescriptionOccurs when string data is truncated from the right.
    Function

    SQLBulkOperations, SQLExecDirect, SQLExecute, SQLFetch, SQLFetchScroll,

    SQLParamData, SQLPutData, SQLSetDescField, SQLSetPos

  • 22002

    DescriptionOccurs when an indicator variable is requested but not provided.
    Function

    SQLExecDirect, SQLExecute, SQLExtendedFetch, SQLFetch, SQLFetchScroll,

    SQLGetData, SQLParamData

  • 22003

    DescriptionOccurs when the numeric value exceeds the limited range.
    Function

    SQLBulkOperations, SQLExecDirect, SQLExecute, SQLExtendedFetch, SQLFetch,

    SQLFetchScroll, SQLGetData, SQLGetInfo, SQLParamData, SQLPutData, SQLSetPos

  • 22007

    DescriptionInvalid DATETIME format.
    Function

    SQLBulkOperations, SQLExecDirect, SQLExecute, SQLExtendedFetch, SQLFetch,

    SQLFetchScroll, SQLGetData, SQLParamData, SQLPutData, SQLSetPos

  • 22008

    DescriptionOccurs when an overflow occurs in the DATETIME field.
    FunctionSQLBulkOperations, SQLExecDirect, SQLExecute, SQLParamData, SQLPutData
  • 22012

    DescriptionOccurs when divided by 0.
    Function

    SQLExecDirect, SQLExecute, SQLExtendedFetch, SQLFetch, SQLFetchScroll,

    SQLGetData, SQLParamData, SQLPutData

  • 22015

    DescriptionOccurs when an overflow occurs in the INTERVAL field.
    Function

    SQLBulkOperations, SQLExecDirect, SQLExecute, SQLExtendedFetch, SQLFetch,

    SQLFetchScroll, SQLGetData, SQLParamData, SQLPutData, SQLSetPos

  • 22018

    .DescriptionOccurs when a character value for cast configuration is invalid.
    Function

    SQLBulkOperations, SQLExecDirect, SQLExecute, SQLExtendedFetch, SQLFetch,

    SQLFetchScroll, SQLGetData, SQLParamData, SQLPutData, SQLSetPos

  • 22019

    DescriptionInvalid escape character.
    FunctionSQLExecDirect, SQLExecute, SQLPrepare
  • 22025

    DescriptionInvalid escape sequence.
    FunctionSQLExecDirect, SQLExecute, SQLPrepare
  • 22026

    DescriptionOccurs when string data has an invalid length.
    FunctionSQLParamData

4.2.9. 23000, 24000, 25000

  • 23000

    DescriptionIntegrity constraint violation
    FunctionSQLBulkOperations, SQLExecDirect, SQLExecute, SQLParamData, SQLSetPos
  • 24000

    DescriptionInvalid cursor state.
    Function

    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

    DescriptionInvalid transaction state.
    FunctionSQLDisconnect

4.2.10. 25S01 ~ 25S03

  • 25S01

    DescriptionTransaction state unknown.
    FunctionSQLEndTran
  • 25S02

    DescriptionOccurs when a transaction is still active.
    FunctionSQLEndTran
  • 25S03

    DescriptionOccurs when a transaction is rolled back.
    FunctionSQLEndTran

4.2.11. 28000, 34000

  • 28000

    DescriptionOccurs when an invalid authority is configured.
    FunctionSQLBrowseConnect, SQLConnect, SQLDriverConnect
  • 34000

    DescriptionInvalid cursor name.
    FunctionSQLExecDirect, SQLPrepare, SQLSetCursorName

4.2.12. 3C000 ~ 3F000

  • 3C000

    DescriptionDuplicated cursor name.
    FunctionSQLSetCursorName
  • 3D000

    DescriptionInvalid catalog name.
    FunctionSQLExecDirect, SQLPrepare, SQLSetConnectAttr
  • 3F000

    DescriptionInvalid schema name.
    FunctionSQLExecDirect, SQLPrepare

4.2.13. 40001 ~ 40003, 42000

  • 40001

    DescriptionOccurs when serialization fails.
    Function

    SQLBulkOperations, SQLColumnPrivileges, SQLColumns, SQLEndTran, SQLExecDirect,

    SQLExecute, SQLFetch, SQLFetchScroll, SQLForeignKeys, SQLGetTypeInfo,

    SQLMoreResults, SQLParamData, SQLPrimaryKeys, SQLProcedureColumns,

    SQLProcedures, SQLSetPos, SQLSpecialColumns, SQLStatistics, SQLTablePrivileges,

    SQLTables

  • 40002

    DescriptionIntegrity constraint violation.
    FunctionSQLEndTran
  • 40003

    DescriptionOccurs when execution has not finished and the transaction state is unknown.
    Function

    SQLBulkOperations, SQLColumnPrivileges, SQLColumns, SQLExecDirect, SQLExecute,

    SQLFetch, SQLFetchScroll, SQLForeignKeys, SQLGetTypeInfo, SQLMoreResults,

    SQLPrimaryKeys, SQLProcedureColumns, SQLProcedures, SQLParamData, SQLSetPos,

    SQLSpecialColumns, SQLStatistics, SQLTablePrivileges, SQLTables

  • 42000

    DescriptionSyntax error or an error that occurs from access violation.
    Function

    SQLBulkOperations, SQLExecDirect, SQLExecute, SQLParamData, SQLPrepare,

    SQLSetPos

4.2.14. 42S01 ~ 42S22, 44000

  • 42S01

    DescriptionOccurs when a base table or view already exists.
    FunctionSQLExecDirect, SQLPrepare
  • 42S02

    DescriptionOccurs when a base table or view cannot be found.
    FunctionSQLExecDirect, SQLPrepare
  • 42S11

    DescriptionOccurs when an index already exists.
    FunctionSQLExecDirect, SQLPrepare
  • 42S12

    DescriptionOccurs when an index cannot be found.
    FunctionSQLExecDirect, SQLPrepare
  • 42S21

    DescriptionOccurs when a column already exists.
    FunctionSQLExecDirect, SQLPrepare
  • 42S22

    DescriptionOccurs when a column cannot be found.
    FunctionSQLExecDirect, SQLPrepare
  • 44000

    DescriptionOccurs from violation of WITH CHECK OPTION.
    FunctionSQLBulkOperations, SQLExecDirect, SQLExecute, SQLParamData, SQLSetPos

4.2.15. HY000 ~ HY024

  • HY000

    DescriptionGeneral error.
    Function

    All ODBC functions except for SQLError, SQLGetDiagField, SQLGetDiagRec

  • HY001

    DescriptionOccurs when memory allocation fails.
    Function

    All ODBC functions except for SQLError, SQLGetDiagField, SQLGetDiagRec

  • HY003

    DescriptionOccurs when an application's buffer type is invalid.
    FunctionSQLBindCol, SQLBindParameter, SQLGetData
  • HY004

    DescriptionOccurs when an SQL data type is invalid.
    FunctionSQLBindParameter, SQLGetTypeInfo
  • HY007

    DescriptionOccurs when the statement is not prepared.
    FunctionSQLCopyDesc, SQLGetDescField, SQLGetDescRec
  • HY008

    DescriptionOccurs when an operation is canceled.
    Function

    SQLBulkOperations, 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

    DescriptionOccurs when NULL pointer is incorrectly used.
    Function

    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

    DescriptionOccurs when there is a problem in a function sequence.
    Function

    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

    DescriptionOccurs when the property cannot currently be configured.
    FunctionSQLBulkOperations, SQLParamData, SQLSetConnectAttr, SQLSetPos, SQLSetStmtAttr
  • HY012

    DescriptionOccurs when a transaction operation code is invalid.
    FunctionSQLEndTran
  • HY013

    DescriptionMemory management error
    FunctionAll ODBC functions except for SQLGetDiagField, SQLGetDiagRec
  • HY014

    DescriptionOccurs when the number of handles exceeds the limit.
    FunctionSQLAllocHandle
  • HY015

    DescriptionOccurs when there is no available cursor name.
    FunctionSQLGetCursorName
  • HY016

    DescriptionOccurs when an implementation row description cannot be changed.
    FunctionSQLCopyDesc, SQLSetDescField, SQLSetDescRec
  • HY017

    DescriptionOccurs when the automatically allocated description handle is incorrectly used.
    FunctionSQLFreeHandle, SQLSetStmtAttr
  • HY018

    DescriptionOccurs when the server denies the cancel request.
    FunctionSQLCancel
  • HY019

    DescriptionOccurs when non-character and non-binary data are sent by being divided into several pieces.
    FunctionSQLPutData
  • HY020

    DescriptionOccurs when attempting to concatenate a NULL value.
    FunctionSQLPutData
  • HY021

    DescriptionInconsistent descriptor information.
    FunctionSQLBindParameter, SQLCopyDesc, SQLGetDescField, SQLSetDescField, SQLSetDescRec
  • HY024

    DescriptionInvalid property value.
    FunctionSQLSetConnectAttr, SQLSetEnvAttr, SQLSetStmtAttr

4.2.16. HY090 ~ HY111

  • HY090

    DescriptionInvalid string or buffer length.
    Function

    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

    DescriptionInvalid descriptor's field identifier.
    FunctionSQLColAttribute, SQLGetDescField, SQLSetDescField
  • HY092

    DescriptionInvalid property or option identifier.
    Function

    SQLAllocHandle, SQLBulkOperations, SQLCopyDesc, SQLDriverConnect, SQLEndTran,

    SQLFreeStmt, SQLGetConnectAttr, SQLGetEnvAttr, SQLGetStmtAttr, SQLParamData,

    SQLSetConnectAttr, SQLSetDescField, SQLSetEnvAttr, SQLSetPos, SQLSetStmtAttr

  • HY095

    DescriptionOccurs when the function type is out of range.
    FunctionSQLGetFunctions
  • HY096

    DescriptionInvalid information type.
    FunctionSQLGetInfo
  • HY097

    DescriptionOccurs when the column is out of range.
    FunctionSQLSpecialColumns
  • HY098

    DescriptionOccurs when the scope type is out of range.
    FunctionSQLSpecialColumns
  • HY099

    DescriptionOccurs when Nullable type is out of range.
    FunctionSQLSpecialColumns
  • HY100

    DescriptionOccurs when a unique option type is out of range.
    FunctionSQLStatistics
  • HY101

    DescriptionOccurs when a precision option type is out of range.
    FunctionSQLStatistics
  • HY103

    DescriptionInvalid retrieval code.
    FunctionSQLDataSources, SQLDrivers
  • HY104

    DescriptionInvalid precision or scale value.
    FunctionSQLBindParameter
  • HY105

    DescriptionInvalid parameter type.
    FunctionSQLBindParameter, SQLExecDirect, SQLExecute, SQLParamData, SQLSetDescField
  • HY106

    DescriptionOccurs when a patch type is out of range.
    FunctionSQLExtendedFetch, SQLFetchScroll
  • HY107

    DescriptionOccurs when a row value is out of range
    FunctionSQLExtendedFetch, SQLFetch, SQLFetchScroll, SQLSetPos
  • HY109

    DescriptionInvalid cursor position.
    Function

    SQLExecDirect, SQLExecute, SQLGetData, SQLGetStmtAttr, SQLNativeSql,

    SQLParamData, SQLSetPos

  • HY110

    DescriptionInvalid driver completion.
    FunctionSQLDriverConnect
  • HY111

    DescriptionInvalid bookmark value.
    FunctionSQLExtendedFetch, SQLFetchScroll

4.2.17. HYC00

  • HYC00

    DescriptionOccurs when trying to use an unimplemented optional feature.
    Function

    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

4.2.18. HYT00 ~ HYT01

  • HYT00

    DescriptionOccurs when timeout is exceeded.
    Function

    SQLBrowseConnect, SQLBulkOperations, SQLColumnPrivileges, SQLColumns,

    SQLConnect, SQLDriverConnect, SQLExecDirect, SQLExecute, SQLExtendedFetch,

    SQLForeignKeys, SQLGetTypeInfo, SQLParamData, SQLPrepare, SQLPrimaryKeys,

    SQLProcedureColumns, SQLProcedures, SQLSetPos, SQLSpecialColumns,

    SQLStatistics, SQLTablePrivileges, SQLTables

  • HYT01

    DescriptionOccurs when database connection timeout is exceeded.
    Function

    All ODBC functions except for SQLDrivers, SQLDataSources,

    SQLGetEnvAttr, SQLSetEnvAttr

4.2.19. IM001 ~ IM015

  • IM001

    DescriptionOccurs when the driver does not provide the function.
    Function

    All ODBC functions except for SQLAllocHandle, SQLDataSources, SQLDrivers,

    SQLFreeHandle, SQLGetFunctions

  • IM002

    DescriptionOccurs when the datasource name cannot be found or default driver does not exist.
    FunctionSQLBrowseConnect, SQLConnect, SQLDriverConnect
  • IM003

    DescriptionOccurs when the specified driver cannot be loaded.
    FunctionSQLBrowseConnect, SQLConnect, SQLDriverConnect
  • IM004

    DescriptionOccurs when an environment handle allocation to the driver by using the SQLAllocHandle function fails.
    FunctionSQLBrowseConnect, SQLConnect, SQLDriverConnect
  • IM005

    DescriptionOccurs when a connection handle allocation to the driver when using the SQLAllocHandle function fails.
    FunctionSQLBrowseConnect, SQLConnect, SQLDriverConnect
  • IM006

    DescriptionOccurs when a database connection property configuration to the driver when using the SQLSetConnectAttr function, fails.
    FunctionSQLBrowseConnect, SQLConnect, SQLDriverConnect
  • IM007

    DescriptionOccurs when a datasource or driver is not specified.
    FunctionSQLDriverConnect
  • IM009

    DescriptionOccurs when translation DDL cannot be loaded.
    FunctionSQLBrowseConnect, SQLConnect, SQLDriverConnect, SQLSetConnectAttr
  • IM010

    DescriptionOccurs when a datasource name is longer than the value specified in the SQL_MAX_DSN_LENGTH parameter.
    FunctionSQLBrowseConnect, SQLConnect, SQLDriverConnect
  • IM011

    DescriptionOccurs when the driver name is too long.
    FunctionSQLBrowseConnect, SQLDriverConnect
  • IM012

    DescriptionOccurs when syntax error occurs in driver reserved words.
    FunctionSQLBrowseConnect, SQLDriverConnect
  • IM013

    DescriptionOccurs when the trace file has a problem.
    FunctionAll ODBC functions
  • IM014

    DescriptionInvalid file DSN name.
    FunctionSQLDriverConnect
  • IM015

    DescriptionDamaged file datasource.
    FunctionSQLDriverConnect

4.2.20. 00000, 02000

  • 00000

    DescriptionOccurs when the function is successfully completed.
    FunctionAll functions
  • 02000

    DescriptionOccurs when the function is successfully completed, but the relevant data is not found.
    FunctionAll functions