Google says:
http://www.cruto.com/resources/vbscript/vbscript-examples/misc/database/Connect-to-a-SQL-Server-Database.asp
That'll get you connected, and shows how to display output to the user. Next thing to find is how to get feedback from the stored procedure so...