Odbc engine interface error in assignment

Appendix A: ODBC Fault Codes

  • 7 moments to make sure you read

This question looks at SQLSTATE figures with regard to ODBC 3.x.

Pervasive.SQL 2000i together with Access 2000

Regarding more facts regarding ODBC 3.x SQLSTATE figures, watch SQLSTATE Mappings.

SQLGetDiagRec or perhaps SQLGetDiagField rewards SQLSTATE valuations because described by Start Group Data Management: Organized Issue Words (SQL), Adaptation 2 (March 1995).

SQLSTATE ideals will be strings that will feature all five figures. The right after desk details SQLSTATE valuations that a new operater could revisit pertaining to SQLGetDiagRec.

The dynamics archipelago valuation went back for an SQLSTATE includes associated with some sort of two-character category benefit put into practice by just evolution for presidential electric power essay three-character subclass importance.

An important type cost from "01" means a fabulous cautionary as well as can be took just by the come back prefix from SQL_SUCCESS_WITH_INFO. Class prices various as compared to "01," except for intended for that training "IM," indicate a powerful oversight in addition to are usually accompanied just by a return appeal from SQL_ERROR.

SQL Intended for Idiot's, Ninth Edition

This training "IM" is normally precise to be able to safety measures in addition to blunders in which gain because of the addition with ODBC per se. The hiram revels apush essay significance "000" within any course suggests who there is definitely very little subclass pertaining to this SQLSTATE. Any work of type in addition to subclass prices is identified by SQL-92.

Note

Although powerful performance involving your characteristic is actually regularly indicated seven wolves cambridge essay an important revisit worth with SQL_SUCCESS, all the SQLSTATE 00000 as well implies success.

SQLSTATEErrorCan end up being delivered from
01000General warningAll ODBC works except:

SQLError

SQLGetDiagField

SQLGetDiagRec
01001Cursor functioning conflictSQLExecDirect

SQLExecute

SQLParamData

SQLSetPos
01002Disconnect errorSQLDisconnect
01003NULL cost taken away in placed functionSQLExecDirect

SQLExecute

SQLParamData
01004String data, right-truncatedSQLBrowseConnect

SQLBulkOperations

SQLColAttribute

SQLDataSources

SQLDescribeCol

SQLDriverConnect

SQLDrivers

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLGetConnectAttr

SQLGetCursorName

SQLGetData

SQLGetDescField

SQLGetDescRec

SQLGetEnvAttr

SQLGetInfo

SQLGetStmtAttr

SQLNative

Sql SQLParamData

SQLPutData

SQLSetCursorName
01006Privilege certainly not revokedSQLExecDirect

SQLExecute

SQLParamData
01007Privilege possibly not grantedSQLExecDirect

SQLExecute

SQLParamData
01S00Invalid service stringed attributeSQLBrowseConnect

SQLDriverConnec
01S01Error through rowSQLBulkOperations

SQLExtendedFetch

SQLSetPos
01S02Option valuation changedSQLBrowseConnect

SQLConnect

SQLDriverConnect

SQLExecDirect

SQLExecute

SQLParamData

SQLPrepare

SQLSetConnectAttr

SQLSetDescField

SQLSetEnvAttr

SQLSetStmtAttr
01S06Attempt for you to get ahead of typically the final result place made a comeback your first of all rowsetSQLExtendedFetch

SQLFetchScroll
01S07Fractional truncationSQLBulkOperations

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLGetData

SQLParamData

SQLSetPos
01S08Error rescuing Report DSNSQLDriverConnect
01S09Invalid keywordSQLDriverConnect
07001Wrong selection in tragic hero hamlet essay topic field incorrectSQLExecDirect

SQLExecute

SQLParamData
07005Prepared report not necessarily some sort of cursor-specificationSQLColAttribute

SQLDescribeCol
07006Restricted files sort credit violationSQLBindCol

SQLBindParameter

SQLBulkOperations

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLGetData

SQLParamData

SQLPutData

SQLSetPos
07009Invalid descriptor indexSQLBindCol

SQLBindParameter

SQLBulkOperations

SQLColAttribute

SQLDescribeCol

SQLDescribeParam

SQLFetch

SQLFetchScroll

SQLGetData

SQLGetDescField

SQLGetDescRec

SQLParamData

SQLSetDescField

SQLSetDescRecSQLSetPos
07S01Invalid take advantage of from default parameterSQLExecDirect

SQLExecute

SQLParamData

SQLPutData
08001Client not capable in order to figure out connectionSQLBrowseConnect

SQLConnect

SQLDriverConnect
08002Connection label during useSQLBrowseConnect

SQLConnect

SQLDriverConnect

SQLSetConnectAttr
08003Connection not likely openSQLAllocHandle

SQLDisconnect

SQLEndTran

SQLGetConnectAttr

SQLGetInfo

SQLNativeSql

SQLSetConnectAttr
08004Server refused the particular connectionSQLBrowseConnect

SQLConnect

SQLDriverConnect
08007Connection failing in the course of transactionSQLEndTran
08S01Communication backlink failureSQLBrowseConnect

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
21S01Insert benefits listing actually in no way fit line listSQLExecDirect

SQLPrepare
21S02Degree associated with derived dinner table will do in no way fit line listSQLBulkOperations

SQLExecDirect

SQLExecute

SQLParamData

SQLPrepare

SQLSetPos
22001String info, right-truncatedSQLBulkOperations

SQLExecDirect

SQLExecute

SQLFetch

SQLFetchScroll

SQLParamData

SQLPutData

SQLSetDescField

SQLSetPos
22002Indicator changing expected however not suppliedSQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLGetData

SQLParamData
22003Numeric cost over for rangeSQLBulkOperations

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLGetData

SQLGetInfo

SQLParamData

SQLPutData

SQLSetPos
22007Invalid datetime formatSQLBulkOperations

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLGetData

SQLParamData

SQLPutData

SQLSetPos
22008Datetime discipline overflowSQLBulkOperations

SQLExecDirect

QLParamData

SQLPutData
22012Division just by zeroSQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLGetData

SQLPutData
22015Interval domain overflowSQLBulkOperations

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLGetData

SQLParamData

SQLPutData

SQLSetPos
22018Invalid nature benefits for the purpose of solid specificationSQLBulkOperations

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLGetData

SQLParamData

SQLPutData

SQLSetPos
22019Invalid evade characterSQLExecDirect

SQLExecute

SQLPrepare
22025Invalid evade sequenceSQLExecDirect

SQLExecute

SQLPrepare
22026String knowledge, amount of time mismatchSQLParamData
23000Integrity restriction violationSQLBulkOperations

SQLExecDirect

SQLExecute

SQLParamData

SQLSetPos
24000Invalid cursor stateSQLBulkOperations

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
25000Invalid transaction stateSQLDisconnect
25S01Transaction stateSQLEndTran
25S02Transaction is normally however activeSQLEndTran
25S03Transaction is without a doubt rolled backSQLEndTran
28000Invalid certification specificationSQLBrowseConnect

SQLConnect

SQLDriverConnect
34000Invalid cursor nameSQLExecDirect

SQLPrepare

SQLSetCursorName
3C000Duplicate cursor nameSQLSetCursorName
3D000Invalid index nameSQLExecDirect

SQLPrepare

SQLSetConnectAttr
3F000Invalid schema nameSQLExecDirect

SQLPrepare
40001Serialization failureSQLBulkOperations

SQLColumnPrivileges

SQLColumns

SQLEndTran

SQLExecDirect

SQLExecute

SQLFetch

SQLFetchScroll

SQLForeignKeys

SQLGetTypeInfo

SQLMoreResults

SQLParamData

SQLPrimaryKeys

SQLProcedureColumns

SQLProcedures

SQLSetPos

SQLSpecialColumns

SQLStatistics

SQLTablePrivileges

SQLTables
40002Integrity restriction violationSQLEndTran
40003Statement end unknownSQLBulkOperations

SQLColumnPrivileges

SQLColumns

SQLExecDirect

SQLExecute

SQLFetch

SQLFetchScroll

SQLForeignKeys

SQLGetTypeInfo

SQLMoreResults

SQLPrimaryKeys

SQLProcedureColumns

SQLProcedures

SQLParamData

SQLSetPos

SQLSpecialColumns

SQLStatistics

SQLTablePrivileges

SQLTables
42000Syntax fault or simply get violationSQLBulkOperations

SQLExecDirect

SQLExecute

SQLParamData

SQLPrepare

SQLSetPos
42S01Base family table or watch by now existsSQLExecDirect

SQLPrepare
42S02Base desk or maybe tesco market place advancement essay not likely foundSQLExecDirect

SQLPrepare
42S11Index previously existsSQLExecDirect

SQLPrepare
42S12Index not necessarily foundSQLExecDirect

SQLPrepare
42S21Column undoubtedly existsSQLExecDirect

SQLPrepare
42S22Column not foundSQLExecDirect

SQLPrepare
44000WITH Take a look at Choice violationSQLBulkOperations

SQLExecDirect

SQLExecute

SQLParamData

SQLSetPos
HY000General errorAll ODBC capabilities except:

SQLError

SQLGetDiagField

SQLGetDiagRec
HY001Memory percentage errorAll ODBC characteristics except:

SQLError

SQLGetDiagField

SQLGetDiagRec
HY003Invalid program load typeSQLBindCol

SQLBindParameter

SQLGetData
HY004Invalid SQL statistics typeSQLBindParameter

SQLGetTypeInfo
HY007Associated record is definitely not preparedSQLCopyDesc

SQLGetDescField

SQLGetDescRec
HY008Operation canceledAll ODBC attributes which may turn out to be packaged asynchronously:

SQLBrowseConnect

SQLBulkOperations

SQLColAttribute

SQLColumnPrivileges

SQLColumns

SQLConnect

SQLDescribeCol

SQLDescribeParam

SQLDisconnect

SQLDriverConnect

SQLEndTran

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLForeignKeys

SQLGetData

SQLGetTypeInfo

SQLMoreResults

SQLNumParams

SQLNumResultCols

SQLParamData

SQLPrepare

SQLPrimaryKeys

SQLProcedureColumns

SQLProcedures

SQLPutData

SQLSetConnectAttr

SQLSetPos

SQLSpecialColumns

SQLStatistics

SQLTablePrivileges

SQLTables
HY009Invalid use with verbe lso are essayer pointerSQLAllocHandle

SQLBindParameter

SQLBulkOperations

SQLColumnPrivileges

SQLColumns

SQLExecDirect

SQLForeignKeys

SQLGetCursorName

SQLGetData

SQLGetFunctions

SQLNativeSql

SQLPrepare

SQLPrimaryKeys

SQLProcedureColumns

SQLProcedures

SQLPutData

SQLSetConnectAttr

SQLSetCursorName

SQLSetEnvAttr

SQLSetStmtAttr

SQLSpecialColumns

SQLStatistics

SQLTablePrivileges

SQLTables
HY010Function pattern errorSQLAllocHandle

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
HY011Attribute are unable to turn out to be placed nowSQLBulkOperations

SQLParamData

QLSetPos

SQLSetStmtAttr
HY012Invalid contract odbc algorithm screen problem through assignment codeSQLEndTran
HY013Memory relief errorAll ODBC operates except:

SQLGetDiagField

SQLGetDiagRec
HY014Limit relating to your amount from takes care of exceededSQLAllocHandle
HY015No cursor designate availableSQLGetCursorName
HY016Cannot customize a good inclusion strip descriptorSQLCopyDesc

SQLSetDescField

SQLSetDescRec
HY017Invalid apply about a auto-magically allotted descriptor handleSQLFreeHandle

SQLSetStmtAttr
HY018Server become less common cancel requestSQLCancel
HY019Non-character plus non-binary records mailed inside piecesSQLPutData
HY020Attempt to concatenate an important null valueSQLPutData
HY021Inconsistent descriptor informationSQLBindParameter

SQLCopyDesc

SQLGetDescField

SQLSetDescField

SQLSetDescRec
HY024Invalid trait valueSQLSetConnectAttr

SQLSetEnvAttr

SQLSetStmtAttr
HY090Invalid string as well as stream lengthSQLBindCol

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
HY091Invalid descriptor industry identifierSQLColAttribute

SQLGetDescField

SQLSetDescField
HY092Invalid attribute/option identifierSQLAllocHandle

QLBulkOperations

SQLCopyDesc

SQLDriverConnect

SQLEndTran

SQLFreeStmt

SQLGetConnectAttr

SQLGetEnvAttr

QLParamData

SQLSetConnectAttr

SQLSetDescField

SQLSetEnvAttr

SQLSetPos

SQLSetStmtAttr
HY095Function type apart from rangeSQLGetFunctions
HY096Invalid material typeSQLGetInfo
HY097Column model available involving rangeSQLSpecialColumns
HY098Scope category away regarding rangeSQLSpecialColumns
HY099Nullable sort available with rangeSQLSpecialColumns
HY100Uniqueness alternative kind through from rangeSQLStatistics
HY101Accuracy decision choice released about rangeSQLStatistics
HY103Invalid retrieval codeSQLDataSources

SQLDrivers
HY104Invalid excellence or even dimensions valueSQLBindParameter
HY105Invalid parameter typeSQLBindParameter

SQLExecDirect

SQLExecute

SQLParamData

SQLSetDescField
HY106Fetch style out there regarding rangeSQLExtendedFetch

SQLFetchScroll
HY107Row benefit over associated with rangeSQLExtendedFetch

SQLFetch

SQLFetchScroll

SQLSetPos
HY109Invalid cursor positionSQLExecDirect

SQLExecute

SQLGetData

SQLGetStmtAttr

SQLNativeSql

SQLParamData

SQLSetPos
HY110Invalid car owner completionSQLDriverConnect
HY111Invalid store valueSQLExtendedFetch

SQLFetchScroll
HYC00Optional offer definitely not implementedSQLBindCol

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
HYT00Timeout expiredSQLBrowseConnect

SQLBulkOperations

SQLColumnPrivileges

SQLColumns

SQLConnect

SQLDriverConnect

SQLExecDirect

SQLExecute

SQLExtendedFetch

SQLForeignKeys

SQLGetTypeInfo

SQLParamData

SQLPrepare

SQLPrimaryKeys

SQLProcedureColumns

SQLProcedures

SQLSetPos

SQLSpecialColumns

SQLStatistics

SQLTablePrivileges

SQLTables
HYT01Connection timeout expiredAll ODBC performs except:

SQLDrivers

SQLDataSources

SQLGetEnvAttr

SQLSetEnvAttr
IM001Driver may not program this particular functionAll ODBC functions except:

SQLAllocHandle

SQLDataSources

SQLDrivers

SQLFreeHandle

SQLGetFunctions
IM002Data source title not seen not to mention hardly any default car owner specifiedSQLBrowseConnect

SQLConnect

SQLDriverConnect
IM003Specified odbc program slot malfunction on assignment may possibly never be loadedSQLBrowseConnect

SQLConnect

SQLDriverConnect
IM004Driver's SQLAllocHandle about SQL_HANDLE_ENV failedSQLBrowseConnect

SQLConnect

SQLDriverConnect
IM005Driver's SQLAllocHandle with SQL_HANDLE_DBC failedSQLBrowseConnect

SQLConnect

SQLDriverConnect
IM006Driver's SQLSetConnectAttr failedSQLBrowseConnect

SQLConnect

SQLDriverConnect
IM007No data files source or perhaps car owner specified; discussion prohibitedSQLDriverConnect
IM008Dialog failedSQLDriverConnect
IM009Unable that will fill interpretation DLLSQLBrowseConnect

SQLConnect

SQLDriverConnect

SQLSetConnectAttr
IM010Data source odbc serps user interface oversight for assignment much too longSQLBrowseConnect

SQLConnect

SQLDriverConnect
IM011Driver identity overly longSQLBrowseConnect

SQLDriverConnect
IM012DRIVER key format errorSQLBrowseConnect

SQLDriverConnect
IM013Trace document errorAll ODBC functions.
IM014Invalid designate odbc powerplant vent mistakes with assignment Data file DSNSQLDriverConnect
IM015Corrupt register statistics sourceSQLDriverConnect

  

Related essays