I tried your code and that worked fine.

When executing my stored proc, after the ors1.open(...), CursorFill returned .F. and the error indicated the ADO recordset was not opened.

Apparently when executing my stored procedure ors1 is not positioned on the first actual recordset. By doing ors1=ors1.nextrecordset and then doing the cursorfill I now get a cursoradapter with the data from the first result set..(??).

Progress!!

>Hi William,
>
>CursorFill() method doesn't report any errors. If it fails it returns .F., you can use AERROR() function to retrieve the error information.
>
>What do CursorFill() and AERROR() return for you?
>
>For me, the following code displays one result after the other as expected (VFP9 SP1, Sql Server 2005):
>

>ors1=CREATEOBJECT("ADODB.Recordset")
>ors1.open("select top 20 * from master..sysprocesses; "+;
>         "select top 20 * from master..sysobjects",;
>         "Provider=SQLOLEDB.1;Integrated Security=SSPI;"+;
>         "Persist Security Info=False;Initial Catalog=master;"+;
>         "Data Source=(local)",3,1)
>
>oca2=CREATEOBJECT("cursoradapter")
>oca2.Alias = "myalias"
>oca2.DataSourceType = "ADO"
>oca2.CursorFill(,,,ors1)
>BROWSE
>
>ors1=ors1.NextRecordset()
>oca2.CursorFill(,,,ors1)
>BROWSE
>

>
>Thanks,
>Aleksey.