The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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)?

asked 08 Jun '12, 05:20

Eric%20Hofer's gravatar image

Eric Hofer
46116
accept rate: 0%

edited 11 Jun '12, 12:40

Martin's gravatar image

Martin
8.6k114149237

1

Wouldn't OleDbDataReader::NextResult() do the trick?

It seems similar to SADataReader's NextResult() method - but that's just a guess...

(08 Jun '12, 05:40) Volker Barth
Replies hidden

NextResult will only return the next row of the result set, but not multiple result sets.

(11 Jun '12, 12:33) Martin

@Martin: "Used to process multiple results that can be generated by executing batch SQL statements." http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbdatareader.nextresult.aspx

(11 Jun '12, 13:58) Breck Carter

@Martin: I don' think so (but I haven't tested that) - reading the next row is what DbDataReader.Read() is for, whereas Eric askes for the next result set...

(11 Jun '12, 15:40) Volker Barth

@Breck, @Volker: You are right, I mixed it with the Read function...

(12 Jun '12, 03:12) Martin

...and now we are waiting on Eric's test results...

(12 Jun '12, 03:53) Volker Barth
showing 1 of 6 show all flat view

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"

permanent link

answered 11 Jun '12, 12:38

Martin's gravatar image

Martin
8.6k114149237
accept rate: 14%

The docs for OleDbDataReader::NextResult() say this: Used to process multiple results that can be generated by executing batch SQL statements. http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbdatareader.nextresult.aspx

(11 Jun '12, 13:59) Breck Carter
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×404
×20
×15
×8

question asked: 08 Jun '12, 05:20

question was seen: 2,267 times

last updated: 12 Jun '12, 03:53