I'm trying to called a stored proc using the Connection.Execute method and

use Output parameters from the stored proc.



I.E.

<%

Set conn = Server.CreateObject("ADODB.Command")

strSQL = "EXEC spStoreProc " & accountID & ",'" & Request("Name") & "',

varResult1 OUTPUT, varResult2 OUTPUT"

conn.Execute strSQL



Response.Write varResult1 & "  " & varResult2

%>



I'm trying to avoid using a Command object and the Parameters collection,

or returning a Recordset like this...

<%

...

Set rs = Server.CreateObject("ADODB.Recordset")

strSQL = ...

Set rs = conn.Execute(strSQL)

...

%>



Why doesn't my way seem to work??



Thanks,  Henry