When developing and running Embedded SQL for C (ESQL/C) programs, you will see different status and error messages. All message numbers that are returned by ESQL/C are negative numbers.
The messages in the following table are generated by ESQL/C. Because the messages are not generated by Microsoft® SQL Server™, they do not appear in the sysmessages table.
Message number | Run time/ compile time | Description |
---|---|---|
4998 | C | Attempt to connect to the specified database sever failed. |
19031 | C | Unable to open bindfile. |
19051 | C | Too many sections. |
19101 | R | Statement too long. |
19103 | R | Illegal %s value %s. Non-numeric %s value %s. (Invalid number for the timeout value.) |
19104 | R/C | Incorrect SQL statement syntax. |
19199 | C | ESQL keyword(s) detected in PREPARE statement. |
19306 | C | Host variable used but not declared. |
19313 | R | Too few host variables. |
19324 | C | Host variable may not be used in this context. |
19408 | R | Invalid SQL data type for SQL_TYP_DECIMAL. |
19413 | R | Data overflow occurred during decimal data conversion. |
19422 | R | Unknown SQL Server data type. |
19423 | R | Invalid destination data type. |
19501 | R | No cursor declared. |
19505 | C | Duplicate cursor name: %s. |
19508 | R | Cursor is not positioned on a row. |
19514 | R | Cursor is not prepared. |
19517 | R | Cursor open attempted for non-SELECT prepared statement. |
19521 | R | Open cursor failure for section %d of plans. |
19523 | R | Failure to locate/close cursor. Section %d, plan %s. |
19524 | R | Table for this cursor not updatable. |
19525 | R | Attempt to fetch on unopened cursor. |
19526 | R | No access plan for this cursor. |
19527 | R | Could not get section for this cursor. |
19528 | R | Connection for section %d of plan %s has NULL DBPROCESS. |
19701 | R | NULL connection name. |
Connection %s not found. | ||
19702 | R | Connection name not found. |
Attempt to close nonexistent connection. | ||
19703 | R | Failed to get DBPROCESS. Autoconnect failure. |
19706 | R | Login failure in section %d. |
19707 | R | Duplicate connection name. |
19822 | R | Improperly initialized user SQLDA. |
19911 | C | The SQL data type specified for a host variable is invalid. |
19913 | C | The token identifier has already been used. |
19917 | C | Invalid or incorrect option to sqlainit(). |
19946 | C | Cursor %s not declared. |
19953 | C | Invalid call type. |
19955 | R | Text not found in %s section %u. |
19956 | R | Access plan section or statement text not found. |
19957 | R | Access plan or statement text not found. |
19994 | R | Can’t run next BEGIN DECLARE sections. Statement ignored. |
19995 | R | END DECLARE encountered without preceding BEGIN DECLARE statement. Statement ignored. |
19999 | C | An internal error occurred. |
Programming Embedded SQL for C