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.