This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Flexera Community
- :
- FlexNet Manager
- :
- FlexNet Manager Knowledge Base
- :
- Oracle Discovery Error 0x800a0e7a "Provider cannot be found. It may not be properly installed." occu...
Subscribe
- Mark as New
- Mark as Read
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
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\
No ratings