Dire need of help with stored procedure output parameters ( ASP, ODBC)

[TheJFM]

Hello people

Here’s the problem.

ASP Page. Connection to SQL 2000 databases using ODBC connectivity.

Calling stored procedure:

CREATE PROCEDURE sp_mySp @HowMany int OUTPUT AS

select * from my_view
where BALANCE < 0

set @HowMany =@@RowCount


How do I call this stored procedure from the ASP page?

I have tried the following and variations on the theme but I get the following error
'Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.'


set NewdbObj=server.createObject(&quot;ADODB.connection&quot

NewdbObj.open session(&quot;myCONNECTION&quot

set cmd=server.createObject(&quot;ADODB.command&quot

cmd.ActiveConnection = NewdbObj

cmd.CommandText = &quot; sp_mySp &quot;

cmd.Parameters.Append cmd.CreateParameter(&quot;@HowMany&quot;, adInteger, adParamOutput)

cmd.Execute

NewdbObj.close



A helping hand here would be very appreciated

 

[Simpleton]

ok after re-reading it the first part (stored procedure change) is optional

change

select * from my_view
where BALANCE < 0

set @HowMany =@@RowCount

in the SP to

select @HowMany = Count(*)
from my_view
where BALANCE < 0


the ado code looks fine, except maybe specifying adParamInputOutput instead.

change this :

cmd.Execute

NewdbObj.close

to

dim nHowMany
cmd.Execute
nHowMany = cmd.Parameters(&quot;@HowMany&quot.value
NewdbObj.close

--
nHowMany not has your answer