[dba-VB] Calling SQL Stored Procedure From Visual Basic 6

To all,
 
I am currently writing a visual basic application with which the back-end will be on SQL Server 7.0.  I currently have a data environment with a command object that links to a stored procedure on the SQL Server.  What I want to be able to do is do away with the DataEnvironment and execute the stored procedure from a module and pass the results (i.e. if I had a SELECT SP into a recordset.
 
Anyone any ideas how to do this.
 
Thanks in advance.
 
Paul Hartland
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
www.freeserve.com/anytime