I am trying to perform a update on a database on another server through a LINKED SERVER configured on my local server. I've tested it and it works perfectly when I use queries in the DBMS.
In my web application, I use hibernate 3.5 and when I try to perform the same query, I get this error:
"The operation could not be performed because OLE DB provider" MSDASQL "for linked server" XYZ "was unable to begin a distributed transaction"
However, if I try to perform the same operation via pure JDBC, it works perfectly.
What is the problem of hibernate with access to external servers?