I have a SQL Server Linked Server configured , pointing to an ODBC – accessing a MongoDB driver . The test connections all work OK – and no problems running an OPENQUERY select statement using the Linked Server.
But when I attempt to run an EXECUTE AT , and attempt to INSERT the data into a #temp table – I get an error message:
Msg 7390, Level 16, State 2, Line 6
The requested operation could not be performed because OLE DB provider “MSDASQL” for linked server “my_linked_server” does
not support the required transaction interface.
Read on to see what the problem is and how you can solve it.