TS ODBC DataServer Error Code listing

Note

Error
Num Internal Name Description Reasons for occurring
1 ISAM_EOF No data found
2 ISAM_TRUNCATION Data truncated
3 ISAM_NOTSUPPORTED Not supported
4 ISAM_ERROR File access error This is similar to the Transoft 913. Look

for problems with TSODBC.INI, server
process not started, invalid IPL
configuration, missing data files or
problems with name resolution.

5 ISAM_NETERROR Communication error Relates to a TCP/IP

configuration problem

6 ISAM_NETVERSION Client/server version

mismatch error

7 ISAM_NET_ISAM Communications parameter

error

8 ISAM_MAXUSERS Too many users May occur because the ODBC

application has cached a
login and the user has
exceeded the number of
licenses. This generally
occurs when using Access or
SQL Server.

9 Used internally

between client and
server.

10 ISAM_DUPLICATE Duplicate record already

exists

11 ISAM_LOGIN_FAILED Login failed
12 ISAM_PSSWD_FAILED Password verification

failed

13 ISAM_ACCESS_DENIED Access table was denied
14 ISAM_READ_ONLY Access to table is read-

only

15 ISAM_READ_ONLY_INST This server is installed

read-only

16 ISAM_INVALID_VALUE Valid Value Test failed for %p should be substituted

column: %p                    with a table or column name

17 ISAM_INPUT_REQUIRED Input is required for %p should be substituted

column: %p                    with a table or column name

18 ISAM_INVALID_DELETE Cannot delete protected

record

19 ISAM_NO_DELETES ODBC cannot delete records %p should be substituted

from table: %p                with a table or column name

Note

20 ISAM_POST_PROCESS_1 Post Processing prevents %p should be substituted

changes to column: %p         with a table or column name

21 ISAM_POST_PROCESS_2 ODBC cannot insert into

tables with Post Processing

22 ISAM_NO_TRIGGERS ODBC cannot update tables

that contain I/O triggers

1001	ERR_MEMALLOCFAIL Memory allocation error
1002	ERR_DATATRUNCATED Data truncated
1003	ERR_NOTSUPPORTED Not supported
1004	ERR_INVALIDCURSORNAME Invalid cursor name
1005	ERR_CURSORNAMEINUSE Cursor name in use
1006	ERR_CONNECTIONINUSE Connection in use
1007	ERR_CURSORSTATE Invalid cursor state
1008	ERR_INVALIDCOLUMNID Invalid column id
1009	ERR_NOTCONVERTABLE Conversion error
1010	ERR_NOTCAPABLE Driver not capable
1011	ERR_OUTOFRANGE Out of range
1012	ERR_ASSIGNMENTERROR Assignment error This can be generated from

bad/invalid data in the
data file. (Characters in
numeric fields).

1013

ERR_UNEXPECTEDEND Unexpected end of SQL

statement

1014

ERR_ELEMENTTOOBIG Lexical element too large:

%s

1015

ERR_EXPECTEDOTHER Expected lexical element

not found: %s

1016	ERR_MALFORMEDNUMBER Malformed number: %s
1017	ERR_UNEXPECTEDTOKEN Unexpected extra token: %s
1018	ERR_BADESCAPE Malformed escape clause: %s
1019	ERR_INTERNAL Internal error
1020	ERR_ISAM File access error
1021	ERR_COLUMNNOTFOUND Column not found: %s
1022	ERR_TABLENOTFOUND Table not found: %s
1023	ERR_UNKNOWNTYPE Data type of parameter

cannot be determined

1024

ERR_INVALIDOPERAND Invalid operand for

operator: %s

Note

1025

ERR_INVALIDTABLENAME Invalid table name: %s

1026

ERR_ORDINALTOOLARGE ORDER BY ordinal greater

than select list count

1027

ERR_ORDERBYTOOLARGE ORDER BY contains too many

columns

1028

ERR_ORDERBYCOLUMNONLY Cannot ORDER BY an

expression

1029

ERR_UNEQUALINSCOLS Unequal number of insert

columns and insert values

1030

ERR_INVALIDINSVAL Insert value must be a

simple value

1031

ERR_INVALIDINVAL Value in an IN expression

must be a simple value

1032

ERR_ALIASINUSE Table alias used multiple

times: %s

1033

ERR_COLUMNONLIST Column on list multiple

times: %s

1034	ERR_INVALIDCOLNAME Invalid column name: %s
1035	ERR_NOSUCHTYPE No such type: %s
1036	ERR_BADPARAMCOUNT Invalid number of

parameters for type: %s

1037

ERR_COLUMNFOUND Column found in multiple

tables: %s

1038	ERR_NODATAFOUND No data found
1039	ERR_INVALIDCONNSTR Invalid connection string
1040	ERR_UNABLETOCONNECT Unable to connect
1041	ERR_PARAMETERMISSING Parameter missing
1042	ERR_DESCOUTOFRANGE Descriptor type out of

range

1043	ERR_OPTOUTOFRANGE Option type out of range
1044	ERR_INFOUTOFRANGE Info type out of range
1045	ERR_CANTORDERBYONTHIS Unable to ORDER BY this

column: %s

1046

ERR_SORT Unable to do ORDER BY

1047

ERR_GROUPBYTOOLARGE GROUP BY contains too many

columns

1048

ERR_CANTGROUPBYONTHIS Unable to GROUP BY this

column: %s

1049

ERR_AGGNOTALLOWED Aggregate function not

allowed in this context: %s

Note

1050

ERR_NOSELECTSTAR SELECT * not allowed if

there is a GROUP BY

1051

ERR_GROUPBY Unable to do GROUP BY

1052

ERR_NOGROUPBY HAVING specified without a

GROUP BY

1053

ERR_ZERODIVIDE Division by zero

1054

ERR_PARAMINSELECT Parameter cannot be used in

select list

1055

ERR_CONCATOVERFLOW String concatenation

overflow

1056

ERR_INVALIDINDEXNAME Invalid index name: %s

1057

ERR_TOOMANYINDEXCOLS To many key columns for

index

1058

ERR_SCALARNOTFOUND Scalar function not found:

%s

1059

ERR_SCALARBADARG Invalid argument to scalar

function: %s

1060

ERR_SCALARNOTSUPPORTED Scalar function not

supported: %s

1061

ERR_TXNINPROGRESS Transaction still active

1062

ERR_DDLENCOUNTERD DDL statement encountered

within a transaction

1063

ERR_DDLIGNORED DDL statement has been

ignored

1064

ERR_DDLCAUSEDACOMMIT Transaction committed

before DDL statement was
executed

1065

ERR_DDLSTATEMENTLOST Prepared DDL statement

deleted (due to commit)
before it could be
executed.

1066

ERR_MULTICOLUMNSELECT SELECT sub-query returns

more than one column.

1067

ERR_NOTSINGLESELECT SELECT sub-query returned

more than one row.

1068	ERR_BADPARAMNUMBER Invalid parameter number.
1069	ERR_OPTIONCHANGED Option value changed.
1070	ERR_KEYSET Unable to create keyset.
1071	ERR_BADFETCHTYPE Fetch type out of range.
1072	ERR_INVALIDBOOKMARK Invalid bookmark value.
1073	ERR_INVALIDROWVAL Row value out of range.

Note

1074	ERR_INVALIDCURPOS Invalid cursor position.
1075	ERR_READONLY Cursor is read-only.
1076	ERR_NOTASSIGNABLE Cannot assign value to an

expression.

1077

ERR_NOTANOPTION Optional feature not

implemented.

1078

ERR_NOTPREPARED Associated statement is not

prepared.

1079

ERR_FUNCSEQUENCE Function sequence error.

1080

ERR_CANTMODIRD Cannot modify an

implementation row
descriptor.

1081

ERR_AUTODESCR Invalid use of an

automatically allocated
descriptor handle.

1082

ERR_INVALIDATTRVAL Invalid attribute value.

1083

ERR_INVALIDDESCFLDID Invalid descriptor field

identifier.

1084

ERR_INVALIDATTRID Invalid attribute

identifier.

1085

ERR_OPTFEATURE Optional feature not

implemented.

1086

ERR_RESULTISNULL Indicator variable required

but not supplied.

1087

ERR_INVALIDDESCRIDX Invalid descriptor index.

1088

ERR_NOTINROWSET Cannot position to a row

you added to the row set.

From the TS ODBC DataServer Reference, version 8.9.1. Open this page in the PDF