Skip navigation
HiTopp
Currently Being Moderated

Executing Remote Stored Procedures

Apr 23, 2012 10:30 AM

Tags: #cfquery #coldfusion #sql #coldfusion9 #stored_procedure #cfstoredproc #sql_server

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).

 
Replies
  • Currently Being Moderated
    Apr 23, 2012 11:10 AM   in reply to HiTopp

    Are you able to run any Stored Procs from that database using ColdFusion?

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points