Dreamweaver can't find Stored Procedure for Recordset

Report · Dec 02, 2016

Hi

I am using DW to run a Stored Procedure and return a recordset. Setting up the Stored Procedure seems fine, There is a small delay but Dreamweaver eventually shows me a list of Stored Procedures in my db and lets me select the one I want.

The problem occurs when I try to enter the recordset, I get the following error,

"[Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'dba.sp_pbs'."

The stored procedure is there, and in SQL Management Studio the stored procedure can be run, so why isn't Dreamweaver finding it?

I am wanting to use a Stored Procedure instead of a straight forward Recordset (Query) as I might need to change the SQL query and using a Stored Procedure means I don't have to keep changing the query in Dreamweaver.

My code

<%

set Command1 = Server.CreateObject("ADODB.Command")

Command1.ActiveConnection = MM_Madics_STRING

Command1.CommandText = "dba.sp_pbs"

Command1.CommandType = 4

Command1.CommandTimeout = 0

Command1.Prepared = true

Command1.Parameters.Append Command1.CreateParameter("@RETURN_VALUE", 3, 4)

Command1.Parameters.Append Command1.CreateParameter("@PBGroup", 200, 1,2,Command1__PBGroup)

Command1.Parameters.Append Command1.CreateParameter("@PB_Description", 200, 1,100,Command1__PB_Description)

set mAd = Command1.Execute

mAd_numRows = 0

%>