TestComplete: Any issues know for connecting to SQL 2016
- 7 years ago
Solution found!!!
It was NOT a SQL Server issue nor connection string issue:
The normal SQL Native Client 11.0 deployed and used is:
SQL Server Native Client 11.0 2011.110.2100.60
or
SQL Server Native Client 11.0 2011.110.3000.0
In testing my connection string against the above SQL Server Native Client 11.0
version, the server does not get recognized correctly with either above versions.
If you install SQL Server 2016, SQL Server Native Client 11.0 version 2011.11.0.65xx.x
also comes along and gets install. For one of my developers, this allows the SQL Server
Native Client 11.0 connection string test to work for him.
So now we narrow down the issue to driver version.
Unaware of any of the latest version of SQL Server Native Client 11.0,
searching on the internet I came across:
https://www.microsoft.com/en-us/download/details.aspx?id=50402
Microsoft SQL Server 2012 Native Client - QFE (Quick Fix Engineering) – a patch/hotfix
When installed, it is the following version:
SQL Server Native Client 11.0 2011.110.7001.00
higher then what comes with SQL 2016 Server.
So the hotfix must have come from SQL 2016 breaking other users like myself.
In manually testing my connection string against the above SQL Server Native Client 11.0
version, the server does get recognized correctly and the connection test PASSES.
Testing in automation using TestComplete now works as well for that testing
using SQL Server Native Client 11.0 2011.110.7001.00.
So from what all that was explained above, automation is now ok with SQL 2016.
The appropriate QFE will be applied accordingly and connection string modified
for SQLNCLI11 use.
Regards,
JamesK