>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?

It could be as simple as this: (assumming that you have an open connection to your db)

Set myRS as New ADODB.Recordset
myCn.sp_VarianceReport "user", "sortfield", #6/12/02#, myRS

This using the connection object's ability to call an sp as if it was a method. The other option is to use an ADO command object.