When attempting to use a SQL resource in SmartConnect, receiving an error that says “Data source name not found and no default driver specified”. This would include things such as
1. GP change data source
2. MSSQL change data source
3. MSSQL lookup columns.
On SmartConnect 2016 and lower, all three of these items use the MSSQL server Native client 10.0 which is the client installed with SQL Server 2008. You can install this from the SqlNativeClient folder on the Microsoft Dynamics GP 2013 installation media.
On SmartConnect 2017 and higher, all three of these items use the MSSQL server Native client 11.0 which is the client installed with SQL Server 2012. You can install this from the SqlNativeClient folder on the Microsoft Dynamics GP 2015 or above installation media.
