VB Forum / Database Access / February 2006

¤
¤ I have a situation where I would like to return a value from a stored
¤ procedure in SQL server, how do I receive the value using ADO?
¤
¤
¤ strSQL = "sp_rename_company '" & strNewCompanyName & "'"
¤ cn.execute strSQL

See if the following helps:

Make ADO Work Faster Using Output Parameters in Your Stored Procedures
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro01/html
/sql01b1.asp

Paul
~~~~
Microsoft MVP (Visual Basic)