Unanswered: Linked Query for Oracle on 64-bit Windows
Hey guys, I am trying to setup a linked query to an oracle server on my 64-bit Windows machine. I installed Sql Server 2008 then 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.'
Need some help on trying to get this to work. Should I not be using MSDAORA or something? Thanks.