1. Ganesan Rajan
  2. PowerBuilder
  3. Thursday, 10 February 2022 06:31 AM UTC

Hi All,

Currently we are using PowerBuilder 2017 R3 to develop and maintain our Product. We are using SQL Native Client (SQLNCLI11) to connect to MS SQL Server.

Whenever we think of PB upgrade, we always pick the PB version which is provided with Long Term Support.

Also we have to consider our customers' requests asking to support latest features in SQL Server like Always On Availability(multisubnet failover) and TLS 1.2 connectivity etc,

So the next version of PowerBuilder should have the following features.

1) Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL)  support to connect to MS SQL Server database. Main purpose is to exploit latest features of MS SQL Server like Mutisubnet failover support.

2) Connect to SQL Server through TLS 1.2

So is it logical to pick PowerBuilder 2019 R3 as our next PB version as it is the long term supported version? If this is not going to help us to meet above point 1&2, what is the next LTSR version.

Your suggestions and help will be much appreciated.

Thanks,

Ganesan R

Accepted Answer
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Monday, 14 February 2022 07:53 AM UTC
  2. PowerBuilder
  3. # Permalink
You should be able to use at least some of the new features, but we cannot guarantee all new features are supported. At a minimum, new data types will not work. I encourage you do a quick test and see if the new features you want to use works. Even if no new SQL Server features are supported in 2019 R3, it is still good to upgrade you get a ton of other new features, bug fixes, plus the tech support period is extended again. 2017 R3 will soon be out of support.
Comment
There are no comments made yet.
Ganesan Rajan Accepted Answer Pending Moderation
  1. Monday, 14 February 2022 07:54 AM UTC
  2. PowerBuilder
  3. # 1

Thanks for the Response. We shall check and get back incase of any issues.

 

Ganesan R

Comment
There are no comments made yet.
Ganesan Rajan Accepted Answer Pending Moderation
  1. Thursday, 10 February 2022 08:13 AM UTC
  2. PowerBuilder
  3. # 2

Thanks Armeen.

I referred this link 

https://docs.appeon.com/pb2019r3/whats_new/MS_SQL_Server_enhancements.html

It says "The MSOLEDBSQL SQL Server interface supports exactly the same features as the SNC SQL Native Client interface does. The additional new features of Microsoft OLE DB Driver (compared to SQL Native Client) will be supported in the next PowerBuilder version."

Does that mean we cannot use the latest features of MS SQL SERVER even if connect via MSOLEDBSQL SQL Server. Because SQL Native Client has some limitations like it cannot support Multisubnet Failover in Availability Groups etc.,

Can you kindly confirm?

Thanks,

Ganesan R

Comment
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 10 February 2022 06:48 AM UTC
  2. PowerBuilder
  3. # 3

Yes, PB 2019 R3 is an LTS version.

Yes, PB 2019 R3 supports the new SQL Server driver (MSOLEDBSQL).

Yes, you should use PB 2019 R3.

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.