I'm using VB6 and SQL7 and I need to pass 4 parameters across to my SP and then I want it to return a message, what's the easiest way to do this as I'm new to SQL.

The stored prodecure works fine as this has already been tested