none
OLE DB provider : The 'OraOLEDB.Oracle.1' provider is not registered on the local machine.

    Question

  • Hi,

    Getting following error while trying to connect to ORACEL database using OLEDB manager.

    Please advice.

    ERROR Log :

    TITLE: Microsoft Visual Studio
    ------------------------------

    Error at RADAR [Connection manager "RADAR_Updated"]: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR.  The requested OLE DB provider OraOLEDB.Oracle.1 is not registered. Error code: 0x00000000.
    An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040154  Description: "Class not registered".

    Error at DFT LOAD AGGTYPE TABLE [RADAR AGG TYPE [1]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "RADAR_Updated" failed with error code 0xC0209302.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.

    ------------------------------
    ADDITIONAL INFORMATION:

    Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)

     


    Dev
    Tuesday, November 23, 2010 1:24 PM

Answers

All replies