Hi Luis,
Check Cursor Type of recordset. Most likely CursorTypeEnum=0 - adOpenForwardOnly in which case recordset doesn't support navigation besides moving toward the end of it. I'm not sure why it causes problrm with VFPCOM.DLL though.


>
> i have this version, I think the problem is with recordset, so that when I use movefirts method 2 times or more, this it gives back the same error, this is without using the VFPCOM.
>
>this is my code..
>
>

>oc=CREATEOBJECT( "adodb.connection" )
>oc.Open( "Provider=sqloledb;Data Source=<My-IP-SERVER>;
Network Library=DBMSSOCN;Initial Catalog=cwebdata;Integrated Security=SSPI;" )
>oc.Execute( "set arithabort on" )
>oc.Execute( "set nocount on" )
>ocom=createobject( "adodb.command" )
>ocom.ActiveConnection = oc
>ocom.CommandText="dbo.pdulistaartdetuni"
>ocom.CommandType=4
>ocom.Parameters.item( "@lnartcla" )=1
>ors1=ocom.Execute
>ors1.MoveFirst
>ors1.MoveFirst
>

>
>
>this is my sotore procedure in SQL Server 2000 SP3..
>
>

>ALTER    PROCEDURE dbo.pdulistaartdetuni ( @lnartcla int )
>AS
>    SELECT adu_cla,art_cla,adu_tip,uni_cla,adu_con FROM dbo.artdetuni 
WHERE art_cla=@lnartcla ORDER BY art_cla
>RETURN
>
>