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

Resolved MSOLEDBSQL Supported?

  1. How-to
2
Votes
Undo
  1. Brian Twardzik
    Brian Twardzik
  2. PowerBuilder
  3. Monday, 15 April 2019 17:41 PM UTC

Hi Appeon & community,

 

Appeon lists support for the OLEDB driver for MSSQL in PB 2017+.

https://www.appeon.com/developers/roadmap/support-sql-server-2017.html

 

The third generation of OLEDB drivers, and only one currently supported by Microsoft is the MSOLEDBSQL driver:

https://docs.microsoft.com/en-us/sql/connect/oledb/oledb-driver-for-sql-server?view=sql-server-2017

 

SNAC 13 has a end of mainstream support date of 2021.

https://techcommunity.microsoft.com/t5/SQL-Server/SNAC-lifecycle-explained/ba-p/385381

 

Will Appeon support use of the MSOLEDBSQL driver, moving forward? Will the SNC option in the provider lists one day disappear?

 

 

Are all workarounds for the MSOLEDBSQL driver listed in one location somewhere?

Reading Data From Excel File Contain Number of She...
How to get Font family from Font
Responses (4)
Mariano Collado @Appeon
Mariano Collado @Appeon Accepted Answer Pending Moderation
  1. Monday, 15 April 2019 21:58 PM UTC
  2. PowerBuilder
  3. # 1

Hi Brian,

While a tech comes along, please take a look at these similar entries on the Community and their responses:

https://community.appeon.com/index.php/qna/q-a/sql-native-client-support#reply-12700

https://community.appeon.com/index.php/qna/q-a/msoledbsql-connection

Comment
There are no comments made yet.
Thomas Welker
Thomas Welker Accepted Answer Pending Moderation
  1. Tuesday, 4 February 2020 19:16 PM UTC
  2. PowerBuilder
  3. # 2

In the PowerBuilder 2019 R2 Documentation, it lists support for SQL Server 2019 using the SQL Native Client interface (SNAC):

https://docs.appeon.com/appeon_online_help/pb2019r2/connecting_to_your_database/ch10s01.html

However, as the above question indicates, Microsoft has deprecated this driver and does not officially support it for SQL Server 2019. In the past we were able to connect to SQL Server with older versions of SNAC as long as we didn't use the new features of SQL Server, as explained here:

https://docs.microsoft.com/en-us/archive/blogs/sqlreleaseservices/snac-lifecycle-explained

For example, we used SNAC v11 that shipped with SQL Server 2012 to connect to SQL Server 2014 and SQL Server 2016.

Microsoft has not indicated that SNAC can be used to connect to SQL Server 2019, at least as far as I can tell. So when Appeon lists SQL Server 2019 support for PowerBuilder 2019 R2 using the SQL Server Native Client, we'd like to know what that entails. Is it that Appeon tested a version of SNAC and decided it worked with SQL Server 2019? Or is it that PowerBuilder has been updated to use the new MSOLEDBSQL driver?

Thank you.

Comment
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Tuesday, 4 February 2020 19:38 PM UTC
  2. PowerBuilder
  3. # 3

Appeon is working on supporting the new database driver. I'm not sure when the version with support will be released and what the name of that version will be.

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 4 February 2020 20:23 PM UTC
  2. PowerBuilder
  3. # 4

Hi Brian;

  End of SNC support by SS is   7/14/2026

  Appeon is planning* an update to the OLE-DB driver for PB2019R3

Regards ... Chris

* - not 100% committed at this time.

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.