Error messages with message numbers in the 10,000 range are issued by DB-Library. These messages are listed in the following table.
Error | Error/ |
|
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 | 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. |
10018 | SQLECLOS | Error in closing network connection. |
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 that has a datatype that 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 | SQLETIME | SQL Server connection timed out. |
10025 | SQLEWRIT | Write to SQL Server failed. |
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 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 | SQLEBCNN | Attempt to bulk copy a null value into a server column that does not accept null values. |
10054 | 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 | 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 can be skipped only when copying into the server. |
10069 | SQLEPNUL | NULL program pointer encountered. |
10070 | SQLEBSKERR | Cannot seek in datafile. |
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 | Data locking or modifications cannot be made in a READONLY cursor. |
10091 | SQLCRSTAB | Table name must be determined in operations that involve data locking or modifications. |
10092 | SQLCRSUPDTAB | Update or insert operations that use 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 | 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. |
10106 | SQLEBCPS | The row length exceeds SQL Server's maximum allowable size. |
10107 | SQLEDTC | Microsoft Distributed Transaction Coordinator call failed. |
10108 | SQLENOTIMPL | This function is not supported on this platform at this time. |
10109 | SQLENONFLOAT | Float conversion attempt failed. The source is invalid. |
The following table lists all error severities for DB-Library along with their numerical equivalents and an explanation of the type of error.
| Severity |
|
EXINFO | 1 | Informational, nonerror. |
EXUSER | 2 | User error. |
EXNONFATAL | 3 | Nonfatal error. |
EXCONVERSION | 4 | Error in DB-Library data conversion. |
EXSERVER | 5 | The server has returned an error flag. |
EXTIME | 6 | Timeout period exceeded while waiting for a response from the server — the DBPROCESS is still alive. |
EXPROGRAM | 7 | Coding error in user program. |
EXRESOURCE | 8 | Running out of resources — the DBPROCESS may be dead. |
EXCOMM | 9 | Failure in communication with server — the DBPROCESS is dead. |
EXFATAL | 10 | Fatal error — the DBPROCESS is dead. |
EXCONSISTENCY | 11 | Internal software error — notify your primary support provider. |