1. Daryl Foster
  2. PowerBuilder
  3. Thursday, 11 April 2019 01:47 AM UTC

Hi All,

We have just realized that the Native SQL Server driver in Powerbuilder has Multiple Active Result Sets (MARS) enabled by default.  We haven't really noticed any issue except that every time the application connects, it uses 2 connections.  I don't think we use any MARS features specifically in our code and I can disable it by adding

ProviderString='MARS Connection=FALSE;'

to the DBParm, but I'm wondering why Powerbuilder enables it by default?  Do we really need it? Are we likely to encounter issues if we disable it?

Thanks.

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 22 December 2023 13:35 PM UTC
  2. PowerBuilder
  3. # 1

Hi Daryl;

  This is a feature of SS & it's DB client driver and their default. So basically, you need to override this feature (as you indicated correctly) otherwise you can have multiple DB threads pushing data to your App. Normally, most PB App's were not designed to handle this properly. So setting MARS off has been a long time SS requirement. 

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.