Count i sp

Jeg er temmelig ny indenfor sp, men jeg har lavet følgende kode som skal lave nogle summer for to opslag. Hvis jeg kører sp i SQL Query Analyser, så fungerer det som det skal jeg får retuneret antalord. Men så snart jeg afvikler det fra min asp-side får jeg følgende fejl:
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

Min sp-kode er:
CREATE PROCEDURE dbo.sp_TaelLemmaIaltDk

@par_lemmaDK varchar(125)

AS

declare @antal int, @x int

set @antal = 0

declare cursor_Uden cursor

for (select count(distinct lemmauk) as antal
from tbllemma
where lemmadk = @par_lemmaDk and polysemiuk = 0
group by ordklasseuk, pluralisuk, emneuk, geouk)

open cursor_Uden
FETCH NEXT FROM cursor_Uden
INTO @x

while @@FETCH_STATUS=0
begin
    FETCH NEXT FROM cursor_Uden
    INTO @x
    set @antal = @antal + @x
end

declare cursor_Med cursor
for (Select count(distinct lemmauk)
from tbllemma
where lemmadk = @par_lemmaDk and polysemiuk <> 0
group by ordklasseuk, pluralisuk, emneuk, geouk)

open cursor_Med
FETCH NEXT FROM cursor_Med
INTO @x

while @@FETCH_STATUS=0
begin
    FETCH NEXT FROM cursor_Med
    INTO @x
    set @antal = @antal + @x
end

close cursor_Uden
deallocate cursor_Uden
close cursor_Med
deallocate cursor_Med

select @antal as AntalOrd
GO


Er der nogen der kan hjælpe mig?