MS SQL ADODB connection

[Arual]

We have AutoIt code that performs a connection to an MS SQL database running SQL server 2012, tls 1.0. It has worked successfully for years.

Today, our IT department migrated our database to a new server that is running SQL server 2016, tls 1.2. Now our connection string is no longer working.

Here is the original that was working in SQL server 2012

$sConnStr = "DRIVER={SQL Server};SERVER=servername,port;DATABASE=dbname;UID=user;PWD=pass"

When that would run on the new server in SQL server 2016. We are getting the error [Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error

We tried changing the connection string to 

$sConnStr = "DRIVER={SQL Server Native Client 11.0};SERVER=servername,port;DATABASE=dbname;UID=user;PWD=pass"

The new error we received is [Microsoft]

TCP Provider: An existing connection was forcibly closed by the remote host.

We can log in successfully using SSMS using the server name, port and user/pass.

Any suggestions on what we need to change in order to get the connection to work again?

[Arual]

We finally found a solution that worked just by continuing to test different options. In case this helps anyone else, here is what we found that finally worked.

$sConnStr = "Provider=SQLNCLI11;SERVER=servername,port;DATABASE=dbname;DataTypeCompatibility=80;UID=user;PWD=pass"

 

[mLipok]

Did you try my ADO.au3 UDF   ?

 

btw.
Thanks for sharing interestning soultion for problem with TLS.

 

Edited February 5, 2021 by mLipok