1. Helge Nymoen
  2. PowerBuilder
  3. Thursday, 15 June 2023 19:04 PM UTC


In Powerbuilder 2022, I have a report fetching data from a MS SQL stored procedure returning two result sets. This works fine when connected to a SAP ASE database, but after migrating to MS SQL, it looks like only the first result set from the procedure are being retrieved to the Powerbuilder report.

I'm using ODBC Driver 18 for SQL Server

Any ideas and help would be very much appreciated.


Kind regards,

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 15 June 2023 19:19 PM UTC
  2. PowerBuilder
  3. # 1

Hi Helge;

  Do you have the MARS (Multiple Active Result Sets) feature turned ON or OFF?

For example in SQLCA's DBParm ... ProviderString='MARS Connection=FALSE;'

Note: MARS is OFF by default in ASE but ON by default in SS.

Regards ... Chris

There are no comments made yet.
  • Page :
  • 1

There are no replies made for this question yet.
However, you are not allowed to reply to this question.