>PMJI. This might be an interesting test with the VFPOLEDB provider. Basically, in the SPROC, you'd just change your SELECT to an 'INTO CURSOR' and then 'RETURN SETRESULTSET('cursorname').
I have been trying to figure out the proper syntax to use such an approach. I have the following code presently and I am not sure if there is something I could do to support that approach:
oCommand.Connection.Open()
If oCommandText.Count > 0 Then
For Each lcCommandText In oCommandText
oCommand.CommandText = lcCommandText
oCommand.ExecuteNonQuery()
Next
End If
oCommand.CommandText = tcSQL + " INTO CURSOR Temp"
oCommand.ExecuteNonQuery()
oCommand.CommandText = "RETURN SETRESULTSET(""Temp"")"
oCommand.ExecuteNonQuery()
oDataAdapter.SelectCommand = oCommand
oDataSet = New DataSet
oDataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey
oDataAdapter.Fill(oDataSet)
Basically, the RETURN SETRESULTSET line is the one which is not working. I obtain:
"One or more errors occurred during processing of command."
I guess there is some adjustments that has to be done as I am using the data adapter to fill the dataset. Using that design, is your approach still applicable?