Hi, how can I read/return a recordset from a stored procedure in SQL Server 7? For SQL, I normally use something like:
Code:
cmd.CommandText = "SELECT Name, Addr FROM Employee WHERE Name Like 'A%'
Set rstLocal = cmd.Execute(, , vbReadOnly)
So for a Stored Procedure that I created, I tried:
Code:
cmd.CommandText = "EXEC km_TEST 'dimaccow'"  'This works from Query Analyzer but not VB
Set rstLocal = cmd.Execute(, , vbReadOnly)
km_Test is the Stored Proc and I'm passing a name. Doesn't work from VB for me. What am I doing wrong?

Thanks in advance,
Wade