Why can I not see the Oracle OLE DB provider option in the Database Provider drop down list?

Follow

Q: I’ve installed E/RPM on a 64bit Server 2008 and installed the Oracle 11.2.0.3 32 bit OLE DB drivers. The Oracle database to which I wish to connect ERPM is on a different server. Why can I not see the Oracle OLE DB provider option in the Database Provider dropdown list in the E/RPM Data Store Configuration dialogue?

A: There is an issue with the Oracle 11.2.0.3 client specifically. There is a work-around available.

To complete the installation of the Oracle Provider for OLE DB. Please complete the following steps:

1. Open command prompt, if you are running on Windows 7 or Windows 2008 please make sure to run the command window with "Run As Administrator" privileges.
2. In the command window execute the following command to register the Oracle Provider for OLE DB :

regsvr32 <OracleHome>\bin\OraOLEDB11.dll

Was this article helpful?
0 out of 0 found this helpful

Comments

Powered by Zendesk