MS SQL 2019 - SAP 10 PL02 B1 Client

[yuyukyi]

Hi Experts,

One of our client PC not able to see MSSQL_2019 database in B1 clinet. SAP version is running on version 10Pl02 (sql 2019). Please suggest where can I find sql native client for 2019. Thanks in advanced.

[PierreBrothier · Accepted solution]

Hi,

i've check the administrator guide :

the sql server native client is deprecated and not supported with SQL server 2019.

You have to download "Microsoft ODBC Driver" with min version 17.3

You have installed Microsoft ODBC Driver on the server as well as on the client workstations, as follows:
o If you have installed SQL Server 2016 or 2017, make sure that the Microsoft ODBC driver version is 13.1 or
higher.
o If you have installed SQL Server 2019, make sure that the Microsoft ODBC driver version is 17.3 or higher. 

[yuyukyi · Accepted solution]

Hi, thanks a lot for your reply. It works after installed ODBC driver 17. Thanks again