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.
Here is a sample connection from an application...
connectionString="metadata=res://*/LoggingModel.csdl|res://*/LoggingModel.ssdl|res://*/LoggingModel.msl;provider=System.Data.SqlClient;provider connection string="data source=myServer;initial catalog=DBLogging;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient"