>*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.