FIX: ODBC Long Binary Functions Use SQL_NO_TOTAL Incorrectly

PSS ID Number: Q149137

Article Last Modified on 02-25-2002

• The Microsoft Foundation Classes (MFC)
  • Microsoft Visual C++, 32-bit Editions 4.0, 4.1

Symptoms

Running an application built using the MFC ODBC classes from Visual C++ 4.0 or 4.1 to retrieve CLongBinary data from a database may result in data truncation. If you're using Visual C++ 4.1, the truncation is only evident in release builds; debug builds work as expected.

Cause

There is a programming error in the MFC code that can lead to this behavior. MFC expects SQL_NO_TOTAL to be the return code of the ::SQLGetData() ODBC API. SQL_NO_TOTAL is used by some drivers when retrieving long binary data. In reality, SQL_NO_TOTAL will be returned as a value of one of the parameters of ::SQLGetData().

As a consequence of the bug, a datasource that uses a driver that returns SQL_NO_TOTAL may experience truncation of long binary data. MFC will only call SQLGetData once rather than in a loop until all data is retrieved as is expected by ODBC.

Refer to the MFC source code (Dbrfx.cpp in Mfc\Src), and look at the do while loop in the function CFieldExchange::GetLongBinaryData() for more details.

In MFC 4.1, a fix was implemented, but it was enclosed in conditional compilation directives that only compile the code in debug builds.

Resolution

A new implementation of RFX_LongBinary that avoids this defect in the MFC code is available to assist you in correcting this problem. Simply download the file as described below, run the .exe to expand the source files, and then incorporate them into your project. Replace all occurrences of RFX_LongBinary with the new RFX_LongBinary_Alloc and rebuild.

The following file is available for download from the Microsoft Software Library: