none
Error to connect oracle DB

    Question

  • Hello Guys,

    On my server box(SQL Server 2012), I use my BISM(in Data Tool) to load one table from oracle DB. The connection was tested successfully but loading data always ends up with the error as below.

    Note. Analysis Server has persisted any security information specified as part of the Connection string portion of the Datsource object definition.
    
    
    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 '6faa7257-f404-4dc6-9e22-50663f2cfb30', Name of 'Oracle fff2'.
    
    
    An error occurred while processing the partition 'APPLICATION_258b4794-870c-46b4-8d81-d4d9a0a4e495' in table 'APPLICATION_258b4794-870c-46b4-8d81-d4d9a0a4e495'.
    
    
    The current operation was cancelled because another operation in the transaction failed.
    
    
    Out of line object 'DataSource', referring to ID(s) '6faa7257-f404-4dc6-9e22-50663f2cfb30', has been specified but has not been used.
    
    
    Out of line object 'DataSourceView', referring to ID(s) 'Temp_DSV', has been specified but has not been used.
    
    

    Any idea to share on this?

    Thanks in advance


    Derek


    • Edited by Derek Dai Saturday, September 14, 2013 6:43 PM
    Saturday, September 14, 2013 4:49 PM

Answers