September 23rd, 2013, 04:09 PM
Linked Server SQL to Oracle.
I am trying to select data from an Oracle Server from a SQL Server and I am getting this error:
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;
How do I go about fixing it?
September 23rd, 2013, 04:20 PM
Looks like a server side problem. Try contacting the people who set up the Oracle server and ask them to enable the remote database operations you need.
September 25th, 2013, 09:48 AM
Nothing to setup.
According to them there is nothing additional they need to do on the Oracle end. It should work.