DB-Library Error Messages
This topic describes all DB-Library error messages and severity levels. The information in this topic is divided into two tables. The following table lists the errors alphabetically, along with their severities. The table under DB-Library Error Severities summarizes the error severity levels. Number values corresponding to the errors are passed to the currently installed, user-supplied error handler. For information about creating error handlers, see dberrhandle. To access these error definitions, include the Sqlfront.h and Sqldb.h header files in your program.
The following error values are defined in the Sqlfront.h header file. Errors with a severity of EXCOMM also have a network-related error message appended to the dberrstr value. In addition, EXCOMM errors have network-specific error information in oserr and oserrstr.
| Error number | Error/ Error severity |
Description |
|---|---|---|
| 10000 | SQLEMEM
|
Unable to allocate sufficient memory. |
| 10001 | SQLENULL
|
NULL DBPROCESS pointer encountered. |
| 10002 | SQLENLOG
|
NULL LOGINREC pointer encountered. |
| 10003 | SQLEPWD
|
Login incorrect. |
| 10004 | SQLECONN
|
Unable to connect: SQL Server is unavailable or does not exist. |
| 10005 | SQLEDDNE
|
DBPROCESS is dead or not enabled. |
| 10006 | SQLENULLO
|
Attempt to login with NULL LOGINREC. |
| 10007 | SQLESMSG
|
General SQL Server error: Check messages from SQL Server. |
| 10008 (DB-Library) | SQLEBTOK
|
Bad token from SQL Server: Datastream processing out of synchronization. |
| 10009 | SQLENSPE
|
General nonspecific DB-Library error. |
| 10010 | SQLEREAD
|
Read from SQL Server failed. |
| 10011 | SQLECNOR
|
Column number out of range. |
| 10012 | SQLETSIT
|
Attempt to call dbtsput with an invalid timestamp. |
| 10013 | SQLEPARM
|
Invalid parameter in DB-Library function reference. |
| 10014 | SQLEAUTN
|
Attempt to update the timestamp of a table with no timestamp column. |
| 10015 | SQLECOFL
|
Data conversion resulted in overflow. |
| 10016 | SQLERDCN
|
Requested data conversion does not exist. |
| 10017 | SQLEICN
|
Invalid value for computeid or invalid compute column number. |
| 10019 | SQLENTXT
|
Attempt to get text point/timestamp from a nontext column. |
| 10020 | SQLEDNTI
|
Attempt to use dbtxtsput to put a new text timestamp into a column whose data type is neither SQLTEXT nor SQLIMAGE. |
| 10021 | SQLETMTD
|
Attempt to send too much TEXT data through dbmoretext. |
| 10022 | SQLEASEC
|
Attempt to send an empty command buffer to the SQL Server. |
| 10023 | SQLENTLL
|
Name too long for LOGINREC field. |
| 10024 (DB-Library) | SQLETIME
|
SQL Server connection timed out. |
| 10026 | SQLEMODE
|
Network connection not in correct mode – invalid SQL Server connection. |
| 10027 | SQLEOOB
|
Error in sending out-of-band data to SQL Server. |
| 10028 | SQLEITIM
|
Illegal timeout value specified. |
| 10029 | SQLEDBPS
|
Maximum number of DBPROCESSes already allocated. |
| 10030 | SQLEIOPT
|
Attempt to use invalid dboption. |
| 10031 | SQLEASNL
|
Attempt to set fields in a null LOGINREC. |
| 10032 | SQLEASUL
|
Attempt to set unknown LOGINREC field. |
| 10033 | SQLENPRM
|
NULL parameter not allowed for this dboption. |
| 10034 | SQLEDBOP
|
Invalid or out of range dbn parameter. |
| 10035 | SQLENSIP
|
Negative starting index passed to dbstrcpy. |
| 10036 | SQLECNULL
|
NULL destination variable not allowed. |
| 10037 | SQLESEOF
|
Unexpected EOF from SQL Server. |
| 10038 | SQLERPND
|
Attempt to initiate a new SQL Server operation with results pending. |
| 10039 | SQLECSYN
|
Attempt to convert data stopped by syntax error in source field. |
| 10040 | SQLENONET
|
DB-Library network communications layer not loaded. |
| 10041 | SQLEBTYP
|
Unknown bind type passed to DB-Library function. |
| 10042 | SQLEABNC
|
Attempt to bind to a nonexistent column. |
| 10043 | SQLEABMT
|
User attempted a dbbind with mismatched column and variable types. |
| 10044 | SQLEABNP
|
Attempt to bind using NULL pointers. |
| 10045 | SQLEBNCR
|
Attempt to bind user variable to a nonexistent compute row. |
| 10046 | SQLEAAMT
|
User attempted a dbaltbind with mismatched column and variable types. |
| 10047 | SQLENXID
|
The server did not grant us a distributed-transaction ID. |
| 10048 | SQLEIFNB
|
Illegal field number passed to bcp_control. |
| 10049 | SQLEKBCO
|
1000 rows successfully bulk copied to host file. |
| 10050 | SQLEBBCI
|
Batch successfully bulk copied to SQL Server. |
| 10051 | SQLEKBCI
|
1000 rows sent to SQL Server. |
| 10052 | SQLEBCWE
|
I/O error while writing bcp datafile. |
| 10053 (DB-Library) | SQLEBCNN
|
Attempt to bulk copy a null value into a server column that does not accept null values. |
| 10054 (DB-Library) | SQLEBCOR
|
Attempt to bulk copy an oversized row to SQL Server. |
| 10055 | SQLEBCPI
|
Call bcp_init before any other bcp routines. |
| 10056 | SQLEBCPN
|
Use bcp_bind, bcp_collen, and bcp_colptr only after calling bcp_init with the copy direction set to DB_IN. |
| 10057 | SQLEBCPB
|
Do not use bcp_bind after bcp_init has been passed a non-null input filename. |
| 10058 | SQLEVDPT
|
For bulk copy, all variable-length data must have either a length-prefix or a terminator specified. |
| 10059 | SQLEBIVI
EXPROGRAM |
Use bcp_columns and bcp_colfmt only after bcp_init has been passed a valid input file. |
| 10060 | SQLEBCBC
|
Call bcp_columns before bcp_colfmt. |
| 10061 | SQLEBCFO
|
Host files must contain at least one column: bcp. |
| 10062 | SQLEBCVH
|
Call bcp_exec only after bcp_init has been passed a valid host file. |
| 10063 | SQLEBCUO
|
Unable to open host datafile: bcp. |
| 10064 | SQLEBUOE
|
Unable to open error file: bcp. |
| 10065 | SQLEBWEF
|
I/O error while writing bcp error file. |
| 10066 | SQLEBTMT
|
Attempt to send too much text data with bcp_moretext. |
| 10067 | SQLEBEOF
|
Unexpected EOF encountered in bcp datafile. |
| 10068 | SQLEBCSI
|
Host-file columns may be skipped only when copying into the server. |
| 10069 | SQLEPNUL
|
NULL program pointer encountered. |
| 10070 | SQLEBSKERR
|
Cannot seek in data file. |
| 10071 | SQLEBDIO
|
Bad bulk-copy direction. |
| 10072 | SQLEBCNT
|
Attempt to use bulk copy with a nonexistent server table. |
| 10073 | SQLEMDBP
|
Attempt to set maximum number of DPPROCESS lower than 1. |
| 10075 | SQLCRSINV
|
Invalid cursor statement. |
| 10076 | SQLCRSCMD
|
Attempt to call cursor functions when there are commands waiting to be executed. |
| 10077 | SQLCRSNOIND
|
One of the tables involved in the cursor statement does not have a unique index. |
| 10078 | SQLCRSDIS
|
Cursor statement contains one of the disallowed phrases COMPUTE, UNION, FOR BROWSE, or SELECT INTO. |
| 10079 | SQLCRSAGR
|
Aggregate functions are not allowed in a cursor statement. |
| 10080 | SQLCRSORD
|
Only fully keyset-driven cursors can have ORDER BY, GROUP BY, or HAVING PHRASES. |
| 10081 | SQLCRSMEM
|
Keyset or window scroll size exceeds the memory limitations of this machine. |
| 10082 | SQLCRSBSKEY
|
Keyset cannot be scrolled backward in mixed cursors with a previous fetch type. |
| 10083 | SQLCRSNORES
|
Cursor statement generated no results. |
| 10084 | SQLCRSVIEW
|
A view cannot be joined with another table or a view in a cursor statement. |
| 10085 | SQLCRSBUFR
|
Row buffering should not be turned on when using cursor functions. |
| 10086 | SQLCRSFROWN
|
Row number to be fetched is outside valid range. |
| 10087 | SQLCRSBROL
|
Backward scrolling cannot be used in a forward scrolling cursor. |
| 10088 | SQLCRSFRAND
|
Fetch types RANDOM and RELATIVE can only be used within the keyset of keyset-driven cursors. |
| 10089 | SQLCRSFLAST
|
Fetch type LAST requires fully keyset-driven cursors. |
| 10090 | SQLCRSRO
EXPROGRAM |
Data locking or modifications cannot be made in a READONLY cursor. |
| 10091 | SQLCRSTAB
|
Table name must be determined in operations involving data locking or modifications. |
| 10092 | SQLCRSUPDTAB
|
Update or insert operations using bind variables require single table cursors. |
| 10093 | SQLCRSUPDNB
|
Update or insert operations cannot use bind variables when binding type is NOBIND. |
| 10094 | SQLCRSVIIND
|
The view used in the cursor statement does not include all the unique index columns of the underlying tables. |
| 10095 | SQLCRSNOUPD
|
Update or delete operation did not affect any rows. |
| 10096 | SQLCRSOS2
|
Cursors are not supported for this server. |
| 10097 | SQLEBCSA
EXPROGRAM |
The BCP hostfile %s contains only %ld rows. Skipping all of these rows is not allowed. |
| 10098 | SQLCRSRO
|
Data locking or modifications cannot be made in a READONLY cursor. |
| 10099 | SQLEBCNE
|
The table %s contains only %ld rows. Copying up to row %ld is not possible. |
| 10100 | SQLEBCSK
|
The table %s contains only %ld rows. Skipping all of these rows is not allowed. |
| 10101 | SQLEUVBF
|
Attempt to read unknown version of bcp format file. |
| 10102 | SQLEBIHC
|
Incorrect host-column number found in bcp format file. |
| 10103 | SQLEBWFF
|
I/O error while reading bcp format file. |
| 10104 | SQLNUMVAL
|
The data stored in the DBNUMERIC/DBDECIMAL structure is invalid. |
| 10105 | SQLEOLDVR
|
The SQL Server's TDS is obsolete with this version of DB-Library. |