Home Forums SQL Server 2008 SQL Server 2008 - General How to install an oracle linked server on SQL Server 2008 r2 failover cluster manager RE: How to install an oracle linked server on SQL Server 2008 r2 failover cluster manager

  • I am working with a linked server from SQL to Oracle. I am getting this message when I try to execute any SQL from SQL server to oracle.

    Msg 7308, Level 16, State 1, Procedure UFN_SRBRECR_LIST, Line 7

    OLE DB provider 'MSDAORA' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.

    Can you help me understand what I need to do to fix this?