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:
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="name"
;[connect default] will modify the connection if name is not found
;[sql name] will modify the Sql if ADC.sql="name(args)"
;[sql default] will modify the Sql if name is not found
;Override strings: Connect, UserId, Password, Sql.
;Only the Sql strings support parameters using "?"
;The override strings must not equal "" 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:<BR/>
; (1) First take the access of the connect section.
; (2) If a user entry is found, it will override.
<BR/>
[connect default]
;If we want to disable unknown connect values, we set Access to NoAccess<BR/>
Access=NoAccess
<BR/>
[sql default]
;If we want to disable unknown sql values, we set Sql to an invalid query.
Sql=" "
[connect CustomerDatabase]
Access=ReadWrite
Connect="DSN=AdvWorks"
<BR/>
[sql CustomerById]
Sql="SELECT * FROM Customers WHERE CustomerID = ?"
<BR/>
[connect AuthorDatabase]
Access=ReadOnly
Connect="DSN=MyLibraryInfo;UID=MyUserID;PWD=MyPassword"
<BR/>
[userlist AuthorDatabase]
Administrator=ReadWrite
<BR/>
[sql AuthorById]<BR/>
Sql="SELECT * FROM Authors WHERE au_id = ?"
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:
Keywords: kberrmsg kbprb KB294374
