Microsoft KB Archive/294374

= An error message may be displayed when you use MDAC 2.6 Component Checker =

Article ID: 294374

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Windows 2000 Service Pack 1
 * Microsoft Windows 2000 Service Pack 1

-



This article was previously published under Q294374



SYMPTOMS
If you install Microsoft Data Access Components (MDAC) 2.6, and you run the MDAC Component Checker, you may receive the following error message:

Field 'Size' mismatch: Expect '1405' Got '1374'



CAUSE
This behavior can occur because of the incorrect code in the Msdfmap.ini file that is located in the %Systemroot% folder.



RESOLUTION
To resolve this behavior, insert the following correct code into your Msdfmap.ini file: ;[connect name] will modify the connection if ADC.connect=&quot;name&quot;
 * [connect default] will modify the connection if name is not found
 * [sql name] will modify the Sql if ADC.sql=&quot;name(args)&quot;
 * [sql default] will modify the Sql if name is not found
 * Override strings: Connect, UserId, Password, Sql.
 * Only the Sql strings support parameters using &quot;?&quot;
 * The override strings must not equal &quot;&quot; or they are ignored
 * A Sql entry must exist in each sql section or the section is ignored
 * An Access entry must exist in each connect section or the section is
 * ignored.
 * Access=NoAccess
 * Access=ReadOnly
 * Access=ReadWrite
 * [userlist name] allows specific users to have special access
 * The Access is computed as follows:

 [connect default] Access=NoAccess  [sql default] Sql=&quot; &quot;
 * (1) First take the access of the connect section.
 * (2) If a user entry is found, it will override.
 * If we want to disable unknown connect values, we set Access to NoAccess
 * If we want to disable unknown sql values, we set Sql to an invalid query.

[connect CustomerDatabase] Access=ReadWrite Connect=&quot;DSN=AdvWorks&quot;  [sql CustomerById] Sql=&quot;SELECT * FROM Customers WHERE CustomerID = ?&quot;  [connect AuthorDatabase] Access=ReadOnly Connect=&quot;DSN=MyLibraryInfo;UID=MyUserID;PWD=MyPassword&quot;  [userlist AuthorDatabase] Administrator=ReadWrite  [sql AuthorById] Sql=&quot;SELECT * FROM Authors WHERE au_id = ?&quot; Then, insert your corrected Msdfmap.ini file into the %Systemroot% folder.



MORE INFORMATION
For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

307255 Component Checker: Diagnose problems and reconfigure MDAC installations

301202 How to check for MDAC version

Component Checker is a tool that is used to diagnose MDAC installation issues. This tool can be downloaded from the following Microsoft Web site:

http://microsoft.com/data/download.htm#ccinfo

Keywords: kberrmsg kbprb KB294374

-

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

© Microsoft Corporation. All rights reserved.