2 Replies Latest reply: Apr 30, 2012 6:39 AM by HiTopp RSS

    Executing Remote Stored Procedures

    HiTopp Community Member

      I am trying to execute a stored procedure through ColdFusion.  The stored procedure being executed attempts to insert local data into a remote server table through a linked server.

       

      Attempting the stored procedure call from ColdFusion results in an error:

       

      [Macromedia][SQLServer JDBC Driver]The DBMS returned an unspecified error.  The command code was 253.

       

      However, if the stored procedure is exected within SQL Server Management Studio, the call works correctly, no error.

       

      I am using the same credentials within Management Studio as within ColdFusion (via Datasources).