Numerical list of return codes

The following codes in Table A-1 are informational and have positive values.

**Table A-1: List of informational return codes in numerical order**
0	TDS-OK
100	TDS-NO-ROW-PRESENT
101	TDS-NO-SQL-PRESENT
102	TDS-NO-MSG-PRESENT
103	TDS-NO-PARM-PRESENT
104	TDS-NO-ROWS-RETURNED
200	TDS-ROW-PRESENT
201	TDS-SQL-CMD-PRESENT
202	TDS-INFOMSG-PRESENT
203	TDS-PARM-PRESENT
204	TDS-STATUS-PRESENT
205	TDS-CURSOR-PRESENT
206	TDS-DYNAMIC-PRESENT
207	TDS-MSGID-PRESENT
208	TDS-COMPUTE-PRESENT
401	TDS-TAKE-SYNCPT
405	TDS-BACKED-OUT
500	TDS-RESULTS-COMPLETE

The following codes in Table A-2 represent errors and have negative values.

**Table A-2: List of error return codes in numeric order**
-4	TDS-INVALID-PARAMETER
-5	TDS-ILLEGAL-REQUEST
-6	TDS-WRONG-STATE
-7	TDS-COMMAND-ACTIVE
-8	TDS-ENTRY-NOT-FOUND
-9	TDS-DUPLICATE-ENTRY
-10	TDS-INVALID-ID-VALUE
-11	TDS-STATUS-NOT-RECEIVED
-12	TDS-CANCEL-RECEIVED
-13	TDS-TRUNCATION-OCCURRED
-14	TDS-GWLIB-INTERNAL-ERROR
-15	TDS-GWLIB-UNAVAILABLE
-16	TDS-GWLIB-BAD-VERSION
-17	TDS-GWLIB-NO-STORAGE
-18	TDS-INVALID-TDPROC
-19	TDS-INVALID-IHANDLE
-20	TDS-TRUNCATION-ERROR
-21	TDS-FLOAT-CONVERSION-ERROR
-22	TDS-MONEY-CONVERSION-ERROR
-23	TDS-DATE-CONVERSION-ERROR
-24	TDS-DECIMAL-CONVERSION-ERROR
-25	TDS-GWLIB-FUNCTION-NOT-AVAILABLE
-26	TDS-OVERFLOW
-27	TDS-TRANSLATION-ERROR
-28	TDS-STRING-TOO-SMALL
-30	TDS-SERVER-NOT-FOUND
-31	TDS-CRTABLE-UNAVAILABLE
-32	TDS-NOT-INITIALIZED
-33	TDS-ROUTE-NOT-FOUND
-34	TDS-ROUTE-NOT-AVAILABLE
-39	TDS-EXCEED-MAX-CONN
-40	TDS-INVALID-CONHANDLE
-41	TDS-ADDR-CANNOT-BE-NULL
-42	TDS-BUF-TOO-SMALL
-43	TDS-CANNOT-SET-VALUE
-44	TDS-INVALID-ACTION
-45	TDS-INVALID-TERMINATOR
-49	TDS-RESULTS-CANCELED
-50	TDS-RESULTS-STILL-ACTIVE
-51	TDS-NO-BIND-ISSUED
-52	TDS-NO-NULLINDI-TRUNC
-53	TDS-NO-NULLINDI-NULLRCVD
-60	TDS-NO-COMPUTES-ALLOWED
-70	TDS-NOT-DECLARED
-71	TDS-CURSOR-ALREADY-DECLARED
-72	TDS-CURSOR-NOT-OPEN
-74	TDS-CURSOR-ALREADY-OPEN
-75	TDS-CURSOR-ALREADY-CLOSED
-76	TDS-CURSOR-ALREADY-DEALLOCATED
-77	TDS-CURSOR-NOT-FOUND
-78	TDS-INVALID-CURSOR-FSM
-79	TDS-INVALID-DYNSQL-FSM
-80	TDS-DYNSQL-NOT-PREPARED
-81	TDS-DYNSQL-ALREADY-PREPARED
-82	TDS-DYNSQL-PARMS-ALREADY-DEFINED
-83	TDS-DYNSQL-OUTPUT-DEFINED
-84	TDS-DYNSQL-ALREADY-DEALLOCATED
-85	TDS-DYNSQL-ID-NOT-FOUND
-86	TDS-DYNSQL-NO-STMT-GIVEN
-87	TDS-DYNSQL-IDLEN-TOO-LONG
-89	TDS-DYNSQL-STMT-NOT-FOUND
-171	TDS-INVALID-DATA-TYPE
-172	TDS-INVALID-DATA-CONVERSION
-173	TDS-INVALID-LENGTH
-174	TDS-INVALID-STATUS
-175	TDS-INVALID-VAR-ADDRESS
-176	TDS-INVALID-FLAGS
-177	TDS-INVALID-PRECISION
-178	TDS-INVALID-SCALE
-179	TDS-INVALID-NAMELENGTH
-180	TDS-INVALID-BOOLEAN
-181	TDS-INVALID-DATAFMT-VALUE
-182	TDS-INVALID-CURCLOSOPTION
-183	TDS-INVALID-CURDECLOPTION
-184	TDS-INVALID-CURDECLSTAT
-185	TDS-INVLID-CURINFSTAT
-186	TDS-INVALID-CURUPDSTAT
-187	TDS-INVALID-CUROPENSTAT
-188	TDS-INVALID-DYNSTAT
-189	TDS-INVALID-DYNTYPE
-190	TDS-CMD-NOT-GET-SET
-191	TDS-BUFFLEN-GREATER-TYPE
-192	TDS-BUFFLEN-LESS-TYPE
-193	TDS-INVALID-OP-TYPE
-194	TDS-INVALID-CURSOR-COMMAND
-195	TDS-INVALID-CURINFCMD
-196	TDS-INVALID-DYNSQL-COMMAND
-200	TDS-NO-CURRENT-CURSOR
-201	TDS-NO-CURRENT-DYNSQL
-256	TDS-MSG-SOS
-257	TDS-SOS
-258	TDS-LOG-ERROR
-259	TDS-INVALID-CONTEXT
-260	TDS-CONTROL-NOTLOADED
-261	TDS-CHARSET-NOTLOADED
-262	TDS-DEFAULT-CHARSET-NOTFOUND
-263	TDS-DBCS-CHARSET-NOTFOUND
-264	TDS-CHARSETSRV-NOT-SBCS
-265	TDS-SPA-NOT-SPECIFIED
-4990	TDS-INVALID-PROTOCOL
-4991	TDS-INVALID-STRMLENGTH
-4992	TDS-INVALID-NET-PROTOCOL
-4993	TDS-DRIVER-NOT-SET
-4995	TDS-LOGIN-FAILED
-4996	TDS-SERVER-RETURNED-ERROR
-4997	TDS-CONNECTION-TERMINATED
-4998	TDS-CONNECTION-FAILED