Home Forums SQL Server 2008 Working with Oracle The OLE DB provider "OraOLDB.Oracle" has not been registered. Linked Server RE: The OLE DB provider "OraOLDB.Oracle" has not been registered. Linked Server

  • September 5, 2014 at 4:59 pm

    #1743638

    Jo Pattyn (9/5/2014)

    Do you have the oracle client installed on the server (especially the oledb driver) and rebooted?

    I installed the 64bit and 32 bit client.

    The SSIS Packages having been working for years.

    Thanks.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/