I need to call a stored procedure and pass it three parameters as follows:

CREATE PROCEDURE dbo.sp_VarianceReport
@UserName Varchar (50),
@SortOrder Varchar (25),
@ReportDate smalldatetime

What is the VB6 syntax to open up the recordset that this SP generates?