About this question
We currently connect to SQL Server 2014 with the Native Client without any issues. However, the SQL Server is being upgraded to SQL 2017. I have been told that SQL Native Client will no longer work for connecting, and we need to install the OLE DB driver instead. Is this correct? I have not found much online other than the Native Client is deprecated and also this article on the lifecycle. What impact would this have on existing .Net applications and SSIS packages that connect to the database. Why SQL server Native Client 11 not working fine for SQL Server 2017? Here is a sample connection from an application... connectionString="metadata=res://*/LoggingModel.csdl|res://*/LoggingModel.ssdl|res://*/Loggi
