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

Resolved MSOLEDBSQL Version 19 issue with PB 2019 R3

  1. Issue
0
Votes
Undo
  1. Larry Pettit
    Larry Pettit
  2. PowerBuilder
  3. Thursday, 3 March 2022 22:08 PM UTC

Our application is currently on PowerBuilder 2019 R3.  It works great with MSOLEDBSQL version 18.6.  Last month, MSOLEDBSQL version 19 was released by Microsoft and version 18.6 is now hard to find to download.  New workstations with only version 19 do not connect to the database.  If we install the old version 18.6, it works with no other changes so this is definitely the issue .  Do I need to upgrade my PowerBuilder version to work with MSOLEDBSQL version 19 or do I need to provide version 18.6 to all my clients?  What's the best resolution?

Increase column sizes on hundreds of datawindows
PowerClient app running twice apps
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 3 March 2022 22:26 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Larry;

  The new MSOLEDBSQL version 19 is not yet certified for use with PB2019R or PB2021. Please continue to use version 18.6 until Appeon Engineering releases an MR for this new DB Client driver to PB2019R3 and PB2021. I suspect that Engineering is already aware of this requirement for PB2022 as I have already seen a support ticket for this recently.

Regards ... Chris

Comment
There are no comments made yet.
Responses (2)
Larry Pettit
Larry Pettit Accepted Answer Pending Moderation
  1. Thursday, 3 March 2022 22:25 PM UTC
  2. PowerBuilder
  3. # 1

https://docs.microsoft.com/en-us/sql/connect/oledb/release-notes-for-oledb-driver-for-sql-server?view=sql-server-ver15 talks about a breaking change in version 19.0.  I'll be looking at that tomorrow.

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 3 March 2022 22:35 PM UTC
Thanks for link!
  1. Helpful
Matt Balent
  1. Matt Balent
  2. Monday, 7 March 2022 20:52 PM UTC
Looks like MS is finally fixing a long standing security issue with SQLServer connections...
  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.