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?