Announcement

Collapse
No announcement yet.

E/RPM will not show the Oracle 11.2.0.3 OLE DB provider

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • E/RPM will not show the Oracle 11.2.0.3 OLE DB provider

    E/RPM will not show the Oracle OLE DB provider even though I've installed the Oracle drivers

    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
    Joe Vachon
    Sales Engineer
    _________________________

    1900 Avenue of the Stars, Suite 425
    Los Angeles, CA 90067
    http://www.liebsoft.com
    Main: (800) 829-6263
    International: +1 (310) 550-8575
    Fax: (310) 550-1152
Working...
X