Retrieving recordset from a stored procedure
Posted on 2002-06-11
I am using VB 6 and SQL 7. I am trying to execute a stored procedure using ADO. This stored procedure creates a temptable and places values in it and then returns a record. When I execute this stored procedure in Query Analyzer, it works fine. But I can't get the results using ADO the way I currently have it written. Help! This is the way I currently am writing the code:
strSQL = "exec xxx.dbo.sp_GetValue 2, 'xxx.dbo.people'"
rsAssignedInfo.Open strSQL, cnIssueDatabase, adOpenStatic