Aside from the error messages documented in the said manual, there is another known error that may occur when using c-treeSQL ODBC Driver with Crystal Reports. This error may occur when generating reports that require a left outer join between tables. The cause of this error is due to the syntax used by Crystal Reports when creating the SQL statement. Users can specify the proper syntax to use by changing a key in the Windows registry. For more information about how to change the registry, please refer to the documentation provided at http://support.businessobjects.com/communityCS/TechnicalPapers/cr9_left_outer_join.pdf.
00000
|
Success
|
01000
|
General Warning
|
01000
|
Error while freeing stmt
|
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 result set
|
01S07
|
Fractional Truncation
|
01S08
|
Error saving File DSN
|
01S09
|
Invalid keyword
|
07001
|
Wrong number of parameters
|
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 truncation
|
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
|
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
|
HY000
|
Operation invalid on a Read only connection
|
HY000
|
User cancelled operation
|
HY000
|
Host and Database must be specified
|
HY000
|
Invalid column number
|
HY000
|
Table type out of range
|
HY000
|
No data at execution values pending
|
HY000
|
Not supported for long data
|
HY000
|
Failed to Obtain Mutex Lock
|
HY000
|
Failed to Acquire Mutex Handle
|
HY001
|
Memory Allocation Failure
|
HY003
|
Invalid application buffer type
|
HY004
|
Invalid SQL data type
|
HY007
|
Associated statement is not prepared
|
HY008
|
Operation cancelled
|
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 Info
|
HY024
|
Invalid attribute value
|
HY090
|
Invalid string or buffer length
|
HY091
|
Invalid descriptor field identifier
|
HY092
|
Invalid attribute /option identifier
|
HY093
|
Invalid parameter number
|
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 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 datasource 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
|
HY000
|
Invalid Character Set Name
|
