• 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)
Bill Gates
Bill Gates Accepted Answer Pending Moderation
  1. Tuesday, 2 January 2024 15:01 PM UTC
  2. PowerBuilder
  3. # 1

Thank you Rolands,I get it .

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.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Sunday, 31 December 2023 17:53 PM UTC
  2. PowerBuilder
  3. # 3

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.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.