Microsoft KB Archive/273782

= PRB: Error When You Copy and Paste GUID in Data View Window =

Article ID: 273782

Article Last Modified on 6/4/2001

-

APPLIES TO


 * Microsoft Visual Basic 6.0 Professional Edition
 * Microsoft Visual Basic 6.0 Enterprise Edition

-



This article was previously published under Q273782



SYMPTOMS
When you copy and paste a globally unique identifier (GUID) value from one row in the grid, which the Data View tool provides, to another row, you may receive the following error message:

The value you entered is not consistent with the data type of length of the column



CAUSE
This error occurs because of a change in the Mdt2qd.dll file, which is one of the files in the Data View tool. Mdt2qd.dll file versions later than 2.0.0.8456 exhibit this behavior.



RESOLUTION
To work around this behavior, use version 2.0.0.8456 or earlier of the Mdt2qd.dll file. To unregister the current version and register the new version of Mdt2qd.dll, follow these steps:  On the Start menu, click Run, and type the following command to unregister the current version of the Mdt2qd.dll file:

regsvr32 /u mdt2qd.dll

 Rename Mdt2qd.dll (such as &quot;MDT2QD.old&quot; or &quot;MDT2QD.prv&quot;). Copy the original Mdt2qd.dll file from the Microsoft Visual Studio Service Pack 3 disk. On the Start menu, click Run, and type the following command to register the new Mdt2qd.dll:

regsvr32 mdt2qd.dll

 Restart your computer.

<div class="moreinformation_section">

Steps to Reproduce Behavior
NOTE: These steps are based on Microsoft SQL Server.   Create a table on an available datasource with a datatype of GUID as follows: CREATE TABLE test (Fld1 varchar(20) NULL, MyGuid uniqueidentifier NULL) </li>  Insert a row and data into the table as follows: INSERT INTO test VALUES ('aaa',NEWID) </li> Start Visual Basic 6.0 or any Microsoft application that uses the Data View tools.</li> Create a connection in the Data View tool to the datasource that contains the newly created table.</li> Open the table in the Data View window.</li> Copy the GUID value from the row, and paste this value into another row.</li></ol>

Keywords: kbdatabase kbdataview kbprb KB273782

-

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

© Microsoft Corporation. All rights reserved.