Microsoft KB Archive/158618

= INF: SQLState 22002 Error When Fetching Results =

Article ID: 158618

Article Last Modified on 10/15/2003

-

APPLIES TO


 * Microsoft Open Database Connectivity Software Development Kit 2.5
 * Microsoft ODBC Driver for Microsoft SQL Server 2.5
 * Microsoft ODBC Driver for Microsoft SQL Server 2.65

-



This article was previously published under Q158618



SUMMARY
While fetching results using ODBC SQL Server driver, you may occasionally see the following error message:

SQLState 22002: Indicator variable required but not supplied

This error message is not documented in either the SQL Server driver Help file or the ODBC 2.5 SDK specification document Readme25.txt that ships with the ODBC Desktop Driver Pack 3.0.



MORE INFORMATION
The problem is a documentation bug with the ODBC 2.5 SDK for the SQL State 22002 on SQLFetch. The SQL Server driver follows the ODBC SDK 2.5 specification and returns the error message correctly, as described in the specification.

According to the ODBC 2.5 specification, the driver should return error 22002 on SQLFetch when the data fetched in the particular column is NULL and the SQLBindCol function did not specify a valid pointer for the pcbValue parameter (indicator variable). This is because the driver returns SQL_NULL_DATA in the pcbValue parameter when the data fetched for a particular column is NULL. When the pcbValue is specified as a NULL pointer in your application, the driver raises the correct error message according to the specification.

NOTE: It is generally a good programming practice to specify valid pointers to the pcbValue parameter.

Additional query words: 2.50 2.65 MFC VC++ 4.0

Keywords: KB158618

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.