none
PowerPivot to Oracle 11g connectivity issue RRS feed

  • Question

  • Ran into unexpected problem with PowerPivot:

    1. We have Windows Server 2012 Std 64 bit, MS Excel 2013 32 bit, Oracle client 11.2.0.3 32 bit

    2. TNS names seem to be configured correctly

    3. Still no luck with establishing connection to Oracle database from PowerPivot. The error looks like: 

    The provider 'OraOLEDB.Oracle' is not registered.

    The following system error occurred:  Class not registered

    A connection could not be made to the data source with the DataSourceID of '...', Name of 'Oracle ...'.

    Appreciate any suggestions!

    Thursday, October 9, 2014 7:00 AM

Answers

  • That error message means the application attempting to use the Oracle Provider for OLE DB failed as the provider is not installed, i.e Class is not registered. This can happen on x64 for the following reasons.

    Your application is running as a 64-bit application and the 64-bit Oracle Provider for OLE DB is not installed or registered.
    or
    Your application is running as a 32-bit application and the 32-bit Oracle Provider for OLE DB is not installed or registered.

    The classes are registered on different parts of the registry on x64. 32-bit providers will be under syswow64 node in the registry.

    See similar thread: OraOLEDB is not registered


    Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"

    Please vote an answer helpful if they helped. Please mark an answer(s) as an answer when your question is being answered.

    Thursday, October 9, 2014 5:29 PM