Synopsis
The 32 bit Oracle Provider for OLE DB must be installed in order to gather Oracle Database inventory from a beacon. This article describes an approach to check whether this component is installed and registered.
This may be appropriate to check if Oracle Database inventory gathering from the beacon is failing with the following error message:
Error 0x0800a0e7a "Provider cannot be found. It may not be properly installed." occurred while attempting to access "ADODB.connection".
Error 0x0800a0e7a "Provider cannot be found. It may not be properly installed." occurred while attempting to access "ADODB.connection".
OLE DB provider for Oracle is not installed
Discussion
- Run the following commands in a command shell window with local Administrator rights:
COPY NUL %TEMP%\testoledb.udl %windir%\SysWOW64\rundll32.exe "%ProgramFiles(x86)%\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile %TEMP%\testoledb.udl - Select the Provider tab on the Data Link Properties, and then check whether Oracle Provider for OLE DB exists in the list:
on - edited on by
ChrisG
