hi Sergey

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 

thank you very much.
Luis Martinez