Multiple-step OLE DB operation generated errors. Check each OLE DB status Value, if available. No work was done.

Error:

Multiple-step OLE DB operation generated errors. Check each OLE DB status Value, if available. No work was done.

Snapshot:

Cause:

  • The Compatibility Mode is set to enable in the Properties area of the Point icon.
  • The computer that generates the error must be updated to MDAC to version 2.8.

Workaround 1: De-select Compatibility Mode in the Point icon Properties

  1. Right-click on the Application Shortcut file and then select Properties.
  2. From the application Properties window, select the Compatibility tab.
  3. In the Compatibility mode section, uncheck the Run this program in compatibility mode for box.
  4. Click OK.
  5. Try opening application again.

WORKAROUND 2:  Re-Install the MDAC

 Navigate to C:\Windows\Inf folder.

  1. Search for mdac.inf file.
  2. Right click mdac.inf and Click Install.
  3. When installation wizard prompts for each of the following files, try to browse and locate them in the directories specified.
  • adcjavas.inc – C:\Windows\servicepackfiles\i386
  • handler.reg – C:\Program Files\Common Files\System\msadc
  • MDACRdMe.htm – C:\Program Files\Common Files\System\Ado
  • oledbjvs.inc – C:\Program Files\Common Files\System\Ole DB
  • mssoap1.dll – C:\Program Files\Common Files\MSSoap\Binaries
  • mssoapr.dll – C:\Program Files\Common Files\MSSoap\Binaries

Note:

  • If the required files are not there, you are required to copy OLE DB, msadc, Ole DB and Binaries folders from another computer and place them in the C:\Program Files\Common Files\System32 folder.
  • Otherwise insert Operating system CD later click on OK, later installation succeeds.

 

Leave a Reply

Your email address will not be published.