WinCC PC Runtime V18 Connecting to MSQL 2019 DB

Hi everyone.

I am creating a Wincc Unified PC Runtime V18 application that will connect to a Microsoft SQL Server 2019 database.

I am creating the connection with ODBC through script. I had already done the same thing, however it was with WinCC V17 and MSQL 2014 and it worked. Now with this new configuration it seems like the script is getting stucked on the line "let conn = await HMIRuntime.Database.CreateConnection(connectionstring);"

I tried to build the connectionstring manually and with the dsn file and the result is the same.

Here is an example used: "Driver={SQL Server}; Server=CASSIOLI; Database=cassioli_db;trusted_connection=yes;"

Siemens documentation tell us to use SQL Server driver, I also tried to use ODBC Driver 17 for SQL Server tho, but them I got stucked with failure to authentication and how the documentation says to use the other driver I was not sure if it was due to compatibility of the driver.

Can anyone give some light on this.

Thanks in advance.

Hi everyone, again.

Just for documentation and reference.

I solved the problem by installing ODBC driver version 18.

The version of ODBC I was trying to use is not compatible with SQL 2019. 

In addition Siemens documentation always shows the driver 'SQL Server' on use, but I had to use the 'ODBC Driver 18 for SQL Server' or even 17 I thing would work. Also it was not so clear for me, you have to always add the System DSN and them if you want the File DSN.

You can try to switch to ip address. It will eliminate the need to call DNS (resolver).

But it is hard to tell how much you will gain with this.

After searching for a long time, somehow i got a solution for this issue.

Solution:

Disable auto tuning level of the TCP.

Please follow below steps:

1) Open command Prompt with admin right (Run as Admin) 2) Type “netsh interface tcp set global autotuninglevel=disabled” 3) After running above command restart the machine.

P.S: please put your remarks for this solution.