SQL State Table

The table below lists SQL Sates and their general description.


SQLSTATE

ERROR

01000

General warning

01001

Cursor operation conflict

01002

Disconnect error

01003

NULL value eliminated in set function

01004

String data, right truncated

01006

Privilege not revoked

01007

Privilege not granted

01S00

Invalid connection string attribute

01S01

Error in row

01S02

Option value changed

01S06

Attempt to fetch before the result set returned the first rowset

01S07

Fractional truncation

01S08

Error saving File DSN

01S09

Invalid keyword

07002

COUNT field incorrect

07005

Prepared statement not a cursor-specification

07006

Restricted data type attribute violation

07009

Invalid descriptor index

07S01

Invalid use of default parameter

08001

Client unable to establish connection

08002

Connection name in use

08003

Connection does not exist

08004

Server rejected the connection

08007

Connection failure during transaction

08S01

Communication link failure

21S01

Insert value list does not match column list

21S02

Degree of derived table does not match column list

22001

String data, right truncated

22002

Indicator variable required but not supplied

22003

Numeric value out of range

22007

Invalid datetime format

22008

Datetime field overflow

22012

Division by zero

22015

Interval field overflow

22018

Invalid character value for cast specification

22019

Invalid escape character

22025

Invalid escape sequence

22026

String data, length mismatch

23000

Integrity constraint violation

24000

Invalid cursor state

25000

Invalid transaction state

25S01

Transaction state

25S02

Transaction is still active

25S03

Transaction is rolled back

28000

Invalid authorization specification

34000

Invalid cursor name

3C000

Duplicate cursor name

3D000

Invalid catalog name

3F000

Invalid schema name

40001

Serialization failure

40002

Integrity constraint violation

40003

Statement completion unknown

42000

Syntax error or access violation

42S01

Base table or view already exists

42S02

Base table or view not found

42S11

Index already exists

42S12

Index not found

42S21

Column already exists

42S22

Column not found

44000

WITH CHECK OPTION violation

HY000

General error

HY001

Memory allocation error

HY003

Invalid application buffer type

HY004

Invalid SQL data type

HY007

Associated statement is not prepared

HY008

Operation canceled

HY009

Invalid use of null pointer

HY010

Function sequence error

HY011

Attribute cannot be set now

HY012

Invalid transaction operation code

HY013

Memory management error

HY014

Limit on the number of handles exceeded

HY015

No cursor name available

HY016

Cannot modify an implementation row descriptor

HY017

Invalid use of an automatically allocated descriptor handle

HY018

Server declined cancel request

HY019

Non-character and non-binary data sent in pieces

HY020

Attempt to concatenate a null value

HY021

Inconsistent descriptor information

HY024

Invalid attribute value

HY090

Invalid string or buffer length

HY091

Invalid descriptor field identifier

HY092

Invalid attribute/option identifier

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

HY104

Invalid precision or scale value

HY105

Invalid parameter type

HY106

Fetch type out of range

HY107

Row value out of range

HY109

Invalid cursor position

HY110

Invalid driver completion

HY111

Invalid bookmark value

HYC00

Optional feature not implemented

HYT00

Timeout expired

HYT01

Connection timeout expired

IM001

Driver does not support this function

IM002

Data source name not found and no default driver specified

IM003

Specified driver could not be loaded

IM004

Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed

IM005

Driver’s SQLAllocHandle on SQL_HANDLE_DBC failed

IM006

Driver’s SQLSetConnectAttr failed

IM007

No data source or driver specified; dialog prohibited

IM008

Dialog failed

IM009

Unable to load translation DLL

IM010

Data source name too long

IM011

Driver name too long

IM012

DRIVER keyword syntax error

IM013

Trace file error

IM014

Invalid name of File DSN

IM015

Corrupt file data source

 

See Also

SQL Database Level Errors (12289)