Home Forums SQL Server 2008 Working with Oracle Help with Linked Query Setup for Oracle RE: Help with Linked Query Setup for Oracle

  • October 31, 2011 at 5:00 pm

    #1401361

    coder_t2 (10/31/2011)

    Hey guys, I am trying to setup a linked query to an oracle server on my machine. I am using Sql Server 2008 and a 64-bit OS. I have installed the ODAC for windows and ODBC for RDB drivers for 64-bit windows. However I am getting the following error.

    Msg 7308, Level 16, State 1, Procedure sp_testlinkedserver, Line 1

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

    Any ideas what I am missing? Thanks.

    Have you had the opportunity of checking this? http://sqlservercorner.blogspot.com/2009_03_01_archive.html

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.