"Data Truncated" Error if Path Contains Over 65 Characters

 Last reviewed: September 12, 1996
Article ID: Q149999
The information in this article applies to:
  • Microsoft Query for Windows 95, version 2.0
  • Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Query version 2.0, when you attempt to use an ODBC data source, you may receive the following error message: 

   Data truncated
If you click OK to continue, you can still proceed and use the data source.

CAUSE

This problem may occur if the path defined by the data source is longer than 65 characters. For example, the following path may result in an error message because it is 67 characters in length: 

   c:\apps\msoffice\excel\subdir01\subdir02\subdir03\subdir04\subdir05
This error only occurs when you use the following ODBC 3.0 drivers: 

   Microsoft dBASE Driver
   Microsoft FoxPro Driver
   Microsoft Excel Driver
   Microsoft Text Driver
   Microsoft Paradox Driver

WORKAROUND

To work around this problem, either shorten the path name in which the data resides, or move the database file or files to a path containing fewer characters.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Query version 2.0 for Windows 95. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

KBCategory: kbusage kbtool kberrmsg
KBSubcategory: xlquery

Additional reference words: 2.00 directory folder ODBC 3.00 66 msquery




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.

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.