407-248-1481

QuoteWerks Knowledgebase Topic (Article ID 5954)

MDAC Error: method '`' of object '`' failed

This information applies to :

Article ID
5954

Created/Updated
December 24, 2015

Category


Are you using the most current release of QuoteWerks?
Version 24.0 Build 2
Issue:

When starting QuoteWerks receive error "method '~' of object '~' failed"

Cause 1:

This error indicates that you have a corrupt installation of MDAC (Microsoft Data Access Components) on your computer. Many computer programs, including QuoteWerks require MDAC in order to run properly. QuoteWerks requires MDAC version 2.6 SP2 or higher.


Solution 1:
In most cases, you can simply download and install the latest MDAC version from Microsoft's website Microsoft's website

If that does not correct the problem, then:

See Microsoft knowledgebase article# 307255 on troubleshooting MDAC problems:

http://support.microsoft.com/default.aspx?scid=kb;en-us;307255


Cause 2:
After an operating system upgrade from Microsoft Windows 2000 to Windows 2003 or a Service Pack 2 Upgrade on Windows XP, the oledb32.dll file version running on the computer is not current.

Solution 2:
Verify the oledb32.dll file version currently running on the computer is the correct version. If the oledb32.dll file is not version 2.80.1022.0, you must upgrade the file version:

1. Re-apply Microsoft Data Access Components (MDAC) version 2.8 to ensure that the other MDAC components have been successfully upgraded.

2. If you have downloaded the MDAC 2.8 installation file (MDAC_TYP.exe), run this command from a DOS prompt using a -c switch to specify an extraction directory.

3. Within the extraction directory, extract the oledb32.dll file from the mdacxpac.cab file.

4. Replace the oledb32.dll file located within C:\Program Files\Common Files\System\OLE DB with the extracted file. When prompted if you would like to replace the file click Yes.

5. Register the oledb32.dll by going to Start > RUN and type regsvr32.

Note: In some cases, the oledb32.dll file will appear to be locked and the regsvr32 command may fail. Should this occur, the resolution can be obtained from Microsoft Support.




If you are running Windows XP SP 2 and your computer came or was installed with SP 2 (not via upgrade), you can re-install MDAC on your Windows XP SP 2 machine by following these steps:

1. Right Click on "c:\windows\inf\mdac.inf" and select install
2. When asked for XP CD, insert the CD and browse for the d:\i386 (where D: = CDROM Drive)




A Third Method of Repair:

1) Boot the machine in Safe Mode (no networking) and log in as the administrator

2) Open the folder “C:\Program Files\Common Files\Microsoft Shared” and rename the “DAO” folder to “DAO.old”

3) Open the folder “C:\Program Files\Common Files\System” and rename the “ADO” folder to “ADO.old”, “MSADC” to “MSADC.old” and “OLE DB” to “OLE DB.old”

4) Reboot the machine normally and log in as the administrator

5) Disable any anti-virus or firewall software

6) Open the folder “C:\WINDOWS\inf” right click on the file “mdac.inf” and click the Install option (NB: this may require the XP installation disk)

7) On completion of the re-installation check that the “C:\Program Files\Common Files\Microsoft Shared” now has a “DAO” and “DAO.old” file and that the “C:\Program Files\Common Files\System” folder has “ADO”, “ADO.old”, “MSADC”, “MSADC.old”, “OLE DB” and “OLE DB.old” folders.

8) Open the folder “C:\Program Files\Common Files\System\Ole DB”, right click the oledb32.dll file. If the version is 2.80.1022.0 or older then this needs to be upgraded. Let me know and I will forward instructions on how to do this.

9) Reboot the machine normally and log in as the user

10) Run QuoteWerks and see if the issues have been resolved.



Additional references:

The Microsoft MDAC version checking utility can be downloaded from Microsoft's website at:
http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en

New Search