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

Resolved SQL Server Connections for PB-2019-R3 or PB-2021

  1. How-to
0
Votes
Undo
  1. Roland Smith
    Roland Smith
  2. PowerBuilder
  3. Monday, 13 December 2021 14:28 PM UTC

We are currently on PB-2019 Build 2170. We are going to update to PB-2021.

We currently use SNC for the primary connection to SQL Server with SQLNCLI11 for the Provider dbparm value. We also have code that makes secondary ODBC connections. They also use SQLNCLI11.

I'm wondering if this setup will work unchanged.

I'm also wondering what advantages there are using the new MSOLEDBSQL native driver instead of the older SNC driver.

Use of Theme messes up menu graphics
PB2019 compatibility with Microsoft Visual Studio ...
Responses (1)
mike S
mike S Accepted Answer Pending Moderation
  1. Monday, 13 December 2021 15:50 PM UTC
  2. PowerBuilder
  3. # 1

the current sql server driver roadmap:

Driver history for Microsoft SQL Server - SQL Server | Microsoft Docs

so, as per microsoft, the native client won't be updated.   However, past roadmaps from MSFT listed said other things, so....

 

i think it is more of an issue of whether microsoft will continue shipping it as part of a standard download.   I allow any of the sql server drivers to be used (oledb, 3 versions of native client, msoledb, odbc), so if we find a problem it is easy (via configuration) to change.

 

Comment
Roland Smith
  1. Roland Smith
  2. Monday, 13 December 2021 16:03 PM UTC
Native Client 11 is only supported up to SQL Server 2014. Our app requires SQL Server 2016 or higher so we are already unsupported. Other than being supported by Microsoft, are there any new features or improvements that stand out in the new OLEDB driver?
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Monday, 13 December 2021 16:37 PM UTC
Here are list of features of the new driver: https://docs.microsoft.com/en-us/sql/connect/oledb/features/oledb-driver-for-sql-server-features?view=sql-server-ver15
  1. Helpful
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.