As you didn't mention the connection type I assume it's ADO.
For an example of executing stored procedures through ADO and getting values of OUT parameters you can look here:

http://www.dbasupport.com/forums/sho...threadid=16129