PRB: Improper Installation of MDAC May Return Error Message "Method '~' of Object '~' Failed" at Run Time with ADO Application (255986)



The information in this article applies to:

  • Microsoft Data Access Components 2.1
  • Microsoft Data Access Components 2.1 (GA)
  • Microsoft Data Access Components 2.1 SP1
  • Microsoft Data Access Components 2.1 SP2
  • Microsoft Data Access Components 2.5
  • Microsoft Data Access Components 2.6
  • Microsoft Data Access Components 2.7
  • Microsoft Data Access Components 2.8
  • Microsoft Visual Basic Professional Edition for Windows 5.0
  • Microsoft Visual Basic Professional Edition for Windows 6.0
  • Microsoft Visual Basic Enterprise Edition for Windows 5.0
  • Microsoft Visual Basic Enterprise Edition for Windows 6.0

This article was previously published under Q255986

SYMPTOMS

When you attempt to run simple ActiveX Data Objects (ADO) code in an application, the following error can occur:
"Method '~' of Object '~' Failed"

CAUSE

The most common cause for this error is mismatched DLL files with Microsoft Data Access Components (MDAC).

RESOLUTION

To work around this problem:

MORE INFORMATION

Although this error has not been consistently reproduced, the items in the "Resolution" section appear to be effective in correcting the problem.

The preceding error is only one of the ways that mismatched DLLs may manifest themselves. A different error may occur. The component checker mentioned in the Resolution section will help determine if there are mismatched DLLs.

REFERENCES

For additional information regarding MDAC installation, click the article numbers below to view the articles in the Microsoft Knowledge Base:

232060 HOWTO: MDAC Setup Troubleshooting Guide

217754 HOWTO: Control Which MDAC Version the Package and Deployment Wizard (PDW) Distributes


Modification Type:MinorLast Reviewed:11/3/2003
Keywords:kbprb KB255986