Database return codes
ErrorCode | ErrorName | ErrorDescription |
1 | DB_SQLState_01000 | General warning |
2 | DB_SQLState_01001 | Cursor operation conflict |
3 | DB_SQLState_01002 | Disconnect error |
4 | DB_SQLState_01003 | NULL value eliminated in set function |
5 | DB_SQLState_01004 | String data, right-truncated |
6 | DB_SQLState_01006 | Privilege not revoked |
7 | DB_SQLState_01007 | Privilege not granted |
8 | DB_SQLState_01S00 | Invalid connection string attribute |
9 | DB_SQLState_01S01 | Error in row |
10 | DB_SQLState_01S02 | Option value changed |
11 | DB_SQLState_01S06 | Attempt to fetch before the result set returned the first row set |
12 | DB_SQLState_01S07 | Fractional truncation |
13 | DB_SQLState_01S08 | Error saving File DSN |
14 | DB_SQLState_01S09 | Invalid keyword |
|
|
|
15 | DB_SQLState_07000 | Dynamic SQL error |
16 | DB_SQLState_07001 | Wrong number of parameters |
17 | DB_SQLState_07002 | COUNT field incorrect |
18 | DB_SQLState_07005 | Prepared statement not a cursor-specification |
19 | DB_SQLState_07006 | Restricted data type attribute violation |
20 | DB_SQLState_07009 | Invalid descriptor index |
21 | DB_SQLState_07S01 | Invalid use of default parameter |
|
|
|
22 | DB_SQLState_08000 | Connection exception |
23 | DB_SQLState_08001 | Client unable to establish connection |
24 | DB_SQLState_08002 | Connection name in use |
25 | DB_SQLState_08003 | Connection not open |
26 | DB_SQLState_08004 | Server rejected the connection |
27 | DB_SQLState_08007 | Connection failure during transaction |
28 | DB_SQLState_08S01 | Communication link failure |
|
|
|
29 | DB_SQLState_21000 | Cardinality violation |
30 | DB_SQLState_21S01 | Insert value list does not match column list |
31 | DB_SQLState_21S02 | Degree of derived table does not match column list |
|
|
|
32 | DB_SQLState_22000 | Data exception |
33 | DB_SQLState_22001 | String data, right-truncated |
34 | DB_SQLState_22002 | Indicator variable required but not supplied |
35 | DB_SQLState_22003 | Numeric value out of range |
36 | DB_SQLState_22007 | Invalid datetime format |
37 | DB_SQLState_22008 | Date/time field overflow |
38 | DB_SQLState_22012 | Division by zero |
39 | DB_SQLState_22015 | Interval field overflow |
40 | DB_SQLState_22018 | Invalid character value for cast specification |
41 | DB_SQLState_22019 | Invalid escape character |
42 | DB_SQLState_22025 | Invalid escape sequence |
43 | DB_SQLState_22026 | String data, length mismatch |
|
|
|
44 | DB_SQLState_23000 | Integrity constraint violation |
|
|
|
45 | DB_SQLState_24000 | Invalid cursor state |
|
|
|
46 | DB_SQLState_25000 | Invalid transaction state |
47 | DB_SQLState_25S01 | Transaction state |
48 | DB_SQLState_25S02 | Transaction is still active |
49 | DB_SQLState_25S03 | Transaction is rolled back |
|
|
|
50 | DB_SQLState_28000 | Invalid authorization specification |
|
|
|
51 | DB_SQLState_34000 | Invalid cursor name |
|
|
|
52 | DB_SQLState_3C000 | Duplicate cursor name |
|
|
|
53 | DB_SQLState_3D000 | Invalid catalog name |
|
|
|
54 | DB_SQLState_3F000 | Invalid schema name |
|
|
|
55 | DB_SQLState_40000 | Transaction rollback |
56 | DB_SQLState_40001 | Serialization failure |
57 | DB_SQLState_40002 | Integrity constraint violation |
58 | DB_SQLState_40003 | Statement completion unknown |
|
|
|
59 | DB_SQLState_42000 | Syntax error or access violation |
60 | DB_SQLState_42S01 | Base table or view already exists |
61 | DB_SQLState_42S02 | Base table or view not found |
62 | DB_SQLState_42S11 | Index already exists |
63 | DB_SQLState_42S12 | Index not found |
64 | DB_SQLState_42S21 | Column already exists |
65 | DB_SQLState_42S22 | Column not found |
|
|
|
66 | DB_SQLState_44000 | WITH CHECK OPTION violation |
|
|
|
67 | DB_SQLState_HY000 | General error |
68 | DB_SQLState_HY001 | Memory allocation error |
69 | DB_SQLState_HY003 | Invalid application buffer type |
70 | DB_SQLState_HY004 | Invalid SQL data type |
71 | DB_SQLState_HY007 | Associated statement is not prepared |
72 | DB_SQLState_HY008 | Operation cancelled |
73 | DB_SQLState_HY009 | Invalid use of null pointer |
74 | DB_SQLState_HY010 | Function sequence error |
75 | DB_SQLState_HY011 | Attribute cannot be set now |
76 | DB_SQLState_HY012 | Invalid transaction operation code |
77 | DB_SQLState_HY013 | Memory management error |
78 | DB_SQLState_HY014 | Limit on the number of handles exceeded |
79 | DB_SQLState_HY015 | No cursor name available |
80 | DB_SQLState_HY016 | Cannot modify an implementation row descriptor |
81 | DB_SQLState_HY017 | Invalid use of an automatically allocated descriptor handle |
82 | DB_SQLState_HY018 | Server declined cancel request |
83 | DB_SQLState_HY019 | Non-character and non-binary data sent in pieces |
84 | DB_SQLState_HY020 | Attempt to concatenate a null value |
85 | DB_SQLState_HY021 | Inconsistent descriptor information |
86 | DB_SQLState_HY024 | Invalid attribute value |
87 | DB_SQLState_HY090 | Invalid string or buffer length |
88 | DB_SQLState_HY091 | Invalid descriptor field identifier |
89 | DB_SQLState_HY092 | Invalid attribute/option identifier |
90 | DB_SQLState_HY095 | Function type out of range |
91 | DB_SQLState_HY096 | Invalid information type |
92 | DB_SQLState_HY097 | Column type out of range |
93 | DB_SQLState_HY098 | Scope type out of range |
94 | DB_SQLState_HY099 | Nullable type out of range |
95 | DB_SQLState_HY100 | Uniqueness option type out of range |
96 | DB_SQLState_HY101 | Accuracy option type out of range |
97 | DB_SQLState_HY103 | Invalid retrieval code |
98 | DB_SQLState_HY104 | Invalid precision or scale value |
99 | DB_SQLState_HY105 | Invalid parameter type |
100 | DB_SQLState_HY106 | Fetch type out of range |
101 | DB_SQLState_HY107 | Row value out of range |
102 | DB_SQLState_HY109 | Invalid cursor position |
103 | DB_SQLState_HY110 | Invalid driver completion |
104 | DB_SQLState_HY111 | Invalid bookmark value |
105 | DB_SQLState_HYC00 | Optional feature not implemented |
106 | DB_SQLState_HYT00 | Timeout expired |
107 | DB_SQLState_HYT01 | Connection timeout expired |
|
|
|
108 | DB_SQLState_IM001 | Driver does not support this function |
109 | DB_SQLState_IM002 | Data source name not found and no default driver specified |
110 | DB_SQLState_IM003 | Specified driver could not be loaded |
111 | DB_SQLState_IM004 | Driver's SQLAllocHandle on SQL_HANDLE_ENV failed |
112 | DB_SQLState_IM005 | Driver's SQLAllocHandle on SQL_HANDLE_DBC failed |
113 | DB_SQLState_IM006 | Driver's SQLSetConnectAttr failed |
114 | DB_SQLState_IM007 | No data source or driver specified dialog prohibited |
115 | DB_SQLState_IM008 | Dialog failed |
116 | DB_SQLState_IM009 | Unable to load translation DLL |
117 | DB_SQLState_IM010 | Data source name too long |
118 | DB_SQLState_IM011 | Driver name too long |
119 | DB_SQLState_IM012 | DRIVER keyword syntax error |
120 | DB_SQLState_IM013 | Trace file error |
121 | DB_SQLState_IM014 | Invalid name of File DSN |
122 | DB_SQLState_IM015 | Corrupt file data source |
|
|
|
200 | DB_FunctionNotImplemented | Function not implemented |
255 | DB_SQLState_Unspecified | Unspecified Error |