Environment: InterDEV 6.0 / MS SQLServer v7.0 / IIS 4.0<BR><BR>I am trying to return a status code from a stored procedure, but all I get are empty values (RETURN_VALUE and @Err are blank). The stored procedure returns the values correctly when called from another stored procedure (or when I use the VI IDE to run it), so I know the problem is either my ADO code, some environment issue, or perhaps just bad karma. <BR><BR>I’ve read umpteen wonderful instructional articles about using parameters with stored procedures, and I am using them as a reference; what am I doing wrong? Is it possible that there is an IIS or SQL Server configuration item prohibiting the values from being returned?<BR><BR>I tried ordinals and explicitly naming parameters, either way the values returned were empty. The code below displayed blank values.<BR><BR><BR>--------------------ASP Code:<BR>Set conn = Server.CreateObject("ADODB.Connection")<BR>conn.Co nnectionTimeout = Application("Arp_ConnectionTimeout")<BR>conn.Comma ndTimeout = Application("Arp_CommandTimeout")<BR>conn.Open Application("Arp_ConnectionString"), _<BR>Application("Arp_RuntimeUserName"), _<BR>Application("Arp_RuntimePassword")<BR>Set cmd = Server.CreateObject("ADODB.Command")<BR><BR>cmd.Co mmandText = "dbo.DeleteCheck"<BR>cmd.CommandType = adCmdStoredProc<BR>cmd.ActiveConnection = conn<BR>set mParm = cmd.CreateParameter("RETURN_VALUE", adInteger ,adParamReturnValue)<BR>cmd.Parameters.Append mParm<BR>set mParm = cmd.CreateParameter("@CheckNo", adChar,adParamInput,10,CheckToDelete)<BR>cmd.Param eters.Append mParm<BR>set mParm = cmd.CreateParameter("@Outval", adInteger,adParamOutput)<BR>cmd.Parameters.Append mParm<BR><BR>Set rs = Server.CreateObject ("ADODB.Recordset")<BR><BR>Set rs = cmd.Execute<BR><BR>Response.Write "<BR>Parm 0=" & cmd.Parameters(0).Value <BR>Response.Write "<BR>Parm 2=" & cmd.Parameters(2).Value <BR><BR>Response.Write "<BR>Parm @Outval=" & cmd.Parameters("@Outval").Value <BR>Response.Write "<BR>RETURN_VALUE=" & cmd.Parameters("RETURN_VALUE").Value <BR><BR><BR>-------------------SQL Code<BR>declare @rows int, @BatchStatus char(11), @Err int<BR>SELECT @Err = 3<BR>SELECT Trans.CheckNo, Trans.Amount, Trans.GroupOutID, Trans.IssueDate, GroupOut.BatchOutID, <BR> BatchOut.BatchOutStatus, Account.AccountDesc<BR> FROM Account <BR> INNER JOIN GroupOut ON Account.AccountID = GroupOut.AccountID <BR> INNER JOIN BatchOut ON GroupOut.BatchOutID = BatchOut.BatchOutID <BR> INNER JOIN Trans ON GroupOut.GroupOutID = Trans.GroupOutID <BR> WHERE (Trans.CheckNo = @CheckNo) and (BatchOutStatus &#060;&#062; &#039Closed&#039)<BR><BR>SELECT @rows = @@rowcount<BR><BR>if @rows = 1 <BR> begin<BR> DELETE Trans WHERE CheckNo = @CheckNo <BR> SELECT @Err = 0<BR> end <BR>else<BR> begin <BR> if @rows &#060; 1<BR> SELECT @Err = 1<BR> else <BR> SELECT @Err = 2<BR> end <BR><BR>SELECT @Outval = @Err<BR>RETURN @Err<BR><BR><BR><BR>Thanks!!!!!<BR><BR><BR>