cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Oracle Discovery Error 0x800a0e7a "Provider cannot be found. It may not be properly installed." occurred while attempting to access "ADODB.Recordset".

Oracle Discovery Error 0x800a0e7a "Provider cannot be found. It may not be properly installed." occurred while attempting to access "ADODB.Recordset".

Summary

This article will describe a scenario that product error will occur when Inventory Manager does Polmerge process or Oracle Discovery process, even the corresponding Oracle Drive are installed. The root cause is due to missing a system dll file ('C:\Program Files (x86)\Common Files\System\msadc\msdaprst.dll'). It may have been removed by Symantec antivirus software due to security reasons.

Symptoms

This article will describe a scenario that product error will occur when Inventory Manager does Polmerge process or Oracle Discovery process, even the corresponding Oracle Drive are installed. The root cause is due to missing a system dll file ('C:\Program Files (x86)\Common Files\System\msadc\msdaprst.dll'). It may have been removed by Symantec antivirus software due to security reasons.

The Oracle Discovery error message: Error 0x800a0e7a "Provider cannot be found. It may not be properly installed." occurred while attempting to access "ADODB.Recordset".

This msdaprst.dll is currently a required component for our Oracle Inventory



Cause

For security reason , this file may have been removed by antivirus software.

This Symantec document refers to the PCI DSS standard and specifically CIS Security Configuration Benchmark For Microsoft IIS 7 which contains:
1.1.2 Remove or Rename Well-Known URLs (Scored)
7. Ensure nothing exists at %programfiles%\Common Files\System\msadc

Reference:
The Symantec Documents (https://www.symantec.com/business/support/index?page=content&pmv=print&impressions=&viewlocale=&id=HOWTO83950)
PCI DSS Standard (http://en.wikipedia.org/wiki/Payment_Card_Industry_Data_Security_Standard)
CIS Security Configuration Benchmark For Microsoft IIS 7 (https://benchmarks.cisecurity.org/tools2/iis/CIS_Microsoft_IIS_7_Benchmark_v1.4.0.pdf)

Steps To Reproduce

Please use "Process Monitor" tool to reproduce this with oratrack.exe to connect to a single database instance.
This will show all of the class registry keys accessed.

You will see Result ' PATH_NOT_FOUND' on Process Name "oratrack.exe" , Operation (CreateFile)

Resolution



Workaround

Add file (msdaprst.dll) back C:\Program Files (x86)\Common Files\System\msadc\
Labels (1)
Was this article helpful? Yes No
No ratings
Version history
Last update:
‎Jun 02, 2018 01:02 PM
Updated by: