Why do I get this error when I fetch data in Visual Studio Code from SQL Server:
The operation could not be performed because OLE DB provider “SQLNCLI11” for linked server “185.55.224.193” was unable to begin a distributed transaction.
I saw the query in SQL Server Profiler, and when I run it in SQL, it works fine. But when I try in VS Code, it throws that error.
2