Stored Proc's and Recordsets

[sshafe]

Is there a way to run a stored procedure and then loop through it's results one-by-one?

My case:

run sp_databases (SQL Server stored procedure to return all database on a server)
Then I want to loop through the results.

So how do you execute a stored procedure with recordsets?

Thanks in advance.

 

[spazman]

Try this;

Set SQLTablesRS = dbconn.Execute("EXEC SP_database&quot

Then
Do While Not SQLTablesRS.EOF
What ever code you need here
SQLTablesRS.MoveNext
Loop