While in Interactive SQL, one can enable Sybase to return multiple results by setting the isql_show_multiple_result_sets, and supposedly with an ODBC connection such should work from C#/.NET (not tested yet by us), as we use an OLEDB connector, we have not been able to figure out how to make such work.
As far as I can see, there's a DBPROP that should be set Reflection of OleDBDataReader code
But I cannot seem to pull together something that works.
Has anybody succeeded with this in Sybase Anywhere 12 (ASA12)?
Use a DataAdpater and fill a DataSet (and hope that the implementation of the DataAdapter really obey to the documentation)
From MSDN: "When multiple result sets are added to the DataSet each result set is placed in a separate table"
answered 11 Jun '12, 12:38