• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Does PB 2022 R2 Still not support Microsoft OLE DB Driver for SQL Server 19.x ?

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

Resolved Does PB 2022 R2 Still not support Microsoft OLE DB Driver for SQL Server 19.x ?

  1. Issue
0
Votes
Undo
  1. Bill Gates
    Bill Gates
  2. PowerBuilder
  3. Sunday, 31 December 2023 14:42 PM UTC

Microsoft OLE DB Driver for SQL Server  19.0.0 -- 19.3.2 

SQLCA.DBMS = "MSOLEDBSQL SQL Server"

......

Error:

Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) is not installed.

 

When I chang to Microsoft OLE DB Driver for SQL Server  18.6.7  ,Connect successful.

 

Does PB 2022 R2 Still not support Microsoft OLE DB Driver for SQL Server  19.x ?

Webbrowser WebView2 error
Best way to run Incremental build in quick time?
Responses (3)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Sunday, 31 December 2023 17:53 PM UTC
  2. PowerBuilder
  3. # 1

Hi Bill;

  That means that the SS 2019 DB Client software was not installed. Check with your SS DBA team for that.

Regards .... Chris

Comment
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Sunday, 31 December 2023 22:47 PM UTC
  2. PowerBuilder
  3. # 2

We are using it in production without issues. As Chris said, you must install version 19.x of the db client. You also need to use Provider='MSOLEDBSQL19' in your dbparm. If Provider is set to MSOLEDBSQL then it will expect version 18.x.

https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver16

 

Comment
There are no comments made yet.
Bill Gates
Bill Gates Accepted Answer Pending Moderation
  1. Tuesday, 2 January 2024 15:01 PM UTC
  2. PowerBuilder
  3. # 3

Thank you Rolands,I get it .

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.