1. Daryl Foster
  2. PowerBuilder
  3. Thursday, 11 April 2019

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.



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