Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Cannot retrieve stored procedure result set #2 in Powerbuilder report

  1. Issue
0
Votes
Undo
  1. Helge Nymoen
    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

  1. ODBC
  2. PowerBuilder
  3. SQL Server
  4. Stored Procedure
Check if user running app on Terminal Server vs. C...
Application crashes when using vertical scroll bar...
Responses (1)
Chris Pollach @Appeon
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.