ERROR in using Orcale provider for OLEDB

  • DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider OraOLEDB.Oracle.1 is not registered -- perhaps no 64-bit provider is available. Error code: 0x00000000.

    An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

    Thank you

  • When looking at the error it seems you are trying to run the package in a 64-bit environment where there is no 64-bit Oracle OLE DB provider installed.

    Either run the package in 32-bit mode (if there is a 32-bit Oracle OLE DB provider), or install the 64-bit provider (search Microsoft website for Attunity).

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Yes ..i am running my package on 64 bit machine. But i am not sure to get the drivers for orcale 64 bit.....i guess there is no kind of 64 bit orcale provider, Any suggestions Plz

  • Koen Verbeeck (3/9/2011)


    Either run the package in 32-bit mode (if there is a 32-bit Oracle OLE DB provider), or install the 64-bit provider (search Microsoft website for Attunity).

    Sometimes the answer is right in front of our eyes...

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply