Use the MSOLEDBSQL driver instead.  https://docs.appeon.com/pb2022/connecting_to_your_database/XREF_71227_Supported_versions.html

Hi, Suresh - 

Here is what I use in a Database Profile to connect to The Microsoft-supplied AdventureWorksLT 2019 (demo) database for SQL Server, running locally on my PC using SQL Server 2019 Express:

// Profile AdventureWorksLT 2019
SQLCA.DBMS = "MSOLEDBSQL SQL Server"
SQLCA.ServerName = "xxxxxxxxxxxxxxx\SQLEXPRESS2019"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Database='AdventureWorksLT2019',TrustedConnection=1,TrimSpaces=1,DateFormat='mm/dd/yyyy',DateTimeFormat='mm/dd/yyyy hh:mm:ss',TimeFormat='hh:mm:ss'"

You'll need to download the MSOLEDBSQL client from Microsoft and install it with the downloaded MSI. Here is a link to the latest version, which works with PB2022, but not older versions:

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

Note there are separate downloads/installs for 32-bit (x86) and 64-bit versions. Both can be installed safely on your machine.

Also note you must install it using the .msi, as copying the unpacked files does not work.

HTH, John

Thank you all for the right direction/advise.

I have downloaded the msoledbsql.msi from the Microsoft website.

I am still struggling to install the msoledbsql.msi, it complains that I do not have C++ Redistributable for Visual Studio 2022, but it has been clearly downloaded and installed.

Not sure what to do next. Any suggestions greatly appreciated.

Thanks in Advance

Attached picture of MSOLEDB Driver 19.2

Thank you all for your time and help. I think I have finally resolved the issue.

In a rush to get this issue resolved, I was blindsided in having the DBMS Parameter set wrong in the ini file.

Earlier my --> DBMS = "OLE DB"

I changed it to --> DBMS = "MSOLEDBSQL SQL Server"

and the provider string worked with 'MSOLEDBSQL'

DBParm = "PROVIDER='MSOLEDBSQL',DATASOURCE='D-MIS-DBS011.myserver.ca\DEVM15A,1404',PBCatalogOwner='dbo',DelimitIdentifier='No',PBTrimCatCharColumns='YES',PBTrimCharColumns='YES',PROVIDERSTRING='database=APP_DEV_A;APP=MYAPP-MSOLEDBSQL',StaticBind='No'"

Thanks to Armeen, Roland, and John for all of your advise and it has contributed to the solution.

The clue to see that my DBMS Parameter was set wrong came from John's answer.

Every one of you have helped me in resolving this issue, but I have to mark one as my answer and it's a tough choice, so I Choose Roland's answer as if I would have not downloaded the lower version of MSOLEDBSQL 19.2, I would not have been able to install the Driver and hence connected to the Database.