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

Hi,

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,
Helge

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

Comment
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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.