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
- Right-click on the Application Shortcut file and then select Properties.
- From the application Properties window, select the Compatibility tab.
- In the Compatibility mode section, uncheck the Run this program in compatibility mode for box.
- Click OK.
- Try opening application again.
WORKAROUND 2: Re-Install the MDAC
Navigate to C:\Windows\Inf folder.
- Search for mdac.inf file.
- Right click mdac.inf and Click Install.
- 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.