Microsoft KB Archive/288249

= Visio5: Data Source Client Error When You Connect to a File That Has a Long Path =

Article ID: 288249

Article Last Modified on 5/26/2005

-

APPLIES TO


 * Visio 5.0 Professional
 * Visio 5.0 Professional
 * Visio 5.0 Professional
 * Visio 5.0 Professional
 * Visio 5.0 Enterprise
 * Visio 5.0 Enterprise
 * Visio 5.0 Enterprise
 * Visio 5.0 Enterprise

-



This article was previously published under Q288249



For a Microsoft Visio 2000 version of this article, see 287624.



SYMPTOMS
When Microsoft Visio connects to an Open Database Connectivity (ODBC) data source, you may receive the following error message:

ODBC Driver Error: State:01004,Native:5,Origin:[Microsoft][ODBC Microsoft Access Driver]String data, right truncated



CAUSE
This error message may appear when the complete file path to the data source exceeds 132 (or more) characters. The drive letter or Universal Naming Convention (UNC) (\\ \ ), colon, backslashes, folder name, and file name all count as characters in the path to the source.



RESOLUTION
To resolve this problem, try to shorten the complete file path of the data source to 131 characters or fewer. Suggestions for shortening the path include:
 * Move the data source file closer to the root directory on the drive.
 * Copy the network shared data source file to a local hard disk drive and place it in a folder that is close to the root directory.
 * Create a network share name that is shorter in length.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: Reverse Engineer ODBC prb ipf Data source client error State 01004 Native 5 Origin Microsoft Access Driver String right truncated

Keywords: kbbug kbpending KB288249

-

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

© Microsoft Corporation. All rights reserved.