KnowledgeBase Archive

An Archive of Early Microsoft KnowledgeBase Articles

View on GitHub

Q140534: FIX: "Data Truncated Column" Erroneously Reported

Article: Q140534
Product(s): Microsoft C Compiler
Version(s): winnt:
Operating System(s): 
Keyword(s): kbDatabase kbMFC kbODBC kbVC kbVC400fix
Last Modified: 03-AUG-2001

-------------------------------------------------------------------------------
The information in this article applies to:

- The Microsoft Foundation Classes (MFC), included with:
   - *EDITOR Please do not choose this product*Microsoft Visual C++ for Windows* use 1699 
-------------------------------------------------------------------------------

SYMPTOMS
========

The following ODBC error message occurs each time the application moves to a
another record (X represents the column number):

  Warning: ODBC Success With Info, Data truncated column X.
  State:01004,Native:0,Origin:[Microsoft][ODBC Single-Tier Driver]

CAUSE
=====

The message occurs when you use CLongBinary field variables with database
tracing enabled. Database tracing is enabled by running Tracer.exe and selecting
the DB Tracing check box.

In the RFX_LongBinary() function, the following code returns the SQL_SUCCESS_INFO
warning:

     case CFieldExchange::Fixup:
     // Give empty buffer to find size of entire LongBinary
     AFX_SQL_ASYNC(pFX->m_prs, ::SQLGetData(pFX->m_prs->m_hstmt,
          (unsigned short int)nField, SQL_C_DEFAULT, &w, 0, plLength));

The RFX routine determines the size of the binary field by calling SQLGetData()
with a zero-length buffer. The variable plLength provides the length of the
binary field after the call. Because a zero-length buffer is passed to
SQLGetData(), ODBC returns a warning indicating that there may be a problem.


RESOLUTION
==========

Ignore the warning.

STATUS
======

Microsoft has confirmed this to be a bug in the Microsoft products listed at the
beginning of this article. This problem is fixed in Visual C++ 4.0, and no
reports were made for Visual C++ 2.x.

NOTE: Visual C++ 4.0 is a 32-bit product; therefore, the bug is not fixed in any
version of 16-bit Visual C++.

Additional query words: 2.50 2.51 2.52

======================================================================
Keywords          : kbDatabase kbMFC kbODBC kbVC kbVC400fix 
Technology        : kbAudDeveloper kbMFC
Version           : winnt:
Issue type        : kbbug
Solution Type     : kbfix

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.