>General Structure should be:
>

>*VFP Stored Procedure:
>PROCEDURE DoSomething
>  LPARAMETERS x
>  SELECT * FROM myTable WHERE something = x INTO CURSOR myCursor
>  RETURN SETRESULTSET("myCursor")
>ENDPROC
>

and in VB.NET something like:

>...
>With oCommand
>  .CommandType = CommandType.StoredProcedure
>  .CommandText = "DoSomething"
>  '.Parameters.Add .....
>End With
>da.SelectCommand = oCommand
>da.Fill(oDataSet)

With the store procedure, I end up with the same result. I got an error after a few hundreds of transactions which is the same type of error I got before.