ASP Stored PRocedure

<i><b>Originally posted by : Amit (a_lodha@hotmail.com)</b></i><br />If I try to excute a storedprocedure using execute method of command object and then populate a recordset with it the resultant recordset becomes a forward only recordset. Is there any way that I can use the execute method of command object to run the stored procedure and still make the recordset scrollable.<br />Thanks<br /><br />

<i><b>Originally posted by : Savio Noronha (savion@mailcity.com)</b></i><br /><br />Hi Amit,<br />I even faced this problem when i was using the ADO 1.5. Now i am using the ADO 2.0 which comes with VB6.0<br />Of you can create a Recordset using command object.<br />Here is the sameple code for it<br /><br />g_cmdtestdata.CommandText = "EXEC testdb.dbo.SP_test " <br />g_cmdtestdata.ActiveConnection = g_conn<br />g_cmdtestdata.Open g_cmdBasedata, ,dOpenDynamic, adLockReadOnly<br /><br />Also instead of using the command above you can directly use the "EXEC SP_test" as the first para in the open. Incase you want to use parameters pass them with single quotes<br /><br />------------<br />Amit at 9/25/2000 12:45:01 AM<br /><br />If I try to excute a storedprocedure using execute method of command object and then populate a recordset with it the resultant recordset becomes a forward only recordset. Is there any way that I can use the execute method of command object to run the stored procedure and still make the recordset scrollable.<br />Thanks<br /><br />