>>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.
Oh well. The only upside is that since the errors occur using a SPROC you have to ability to add some logging from within the VFP proc itself.
Just to confirm: these errors are occurring when just running the basic aspx with a query returning a dataset? No framework, no other code in the global.asax ?
Regards,
Viv