<cfstoredproc datasource="DATASOURCE" procedure="PROCEDURE"> <cfprocparam cfsqltype="cf_sql_integer" value="VALUE" /> </cfstoredproc>
I receive the error The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "LINKEDSERVER" was unable to begin a distributed transaction.
However, if I attempt the same call from a basic CFML page, I get no error and the call works just fine.
And to throw another twist into the issue, if I execute the stored procedure above within my application (like normal), but include either the username or password for the local SQL Server (not the remote SQL Server), the call works fine.
Does this lead anybody to believe that the issue is somewhere in the bowels of my application?