Hi,

i was asked why an old OLEDB Connection string, which worked for SQL Server 2014 didn't work for SQL Server 2017.

My answer was: I'm sure that a new driver - installed seperately - is necessary. It has to be installed on the Server AND on each Client

these links should help here

 https://blogs.msdn.microsoft.com/sqlnativeclient/2017/10/06/announcing-the-new-release-of-ole-db-driver-for-sql-server/

 https://blogs.msdn.microsoft.com/sqlnativeclient/2018/03/30/released-microsoft-ole-db-driver-for-sql-server/

 Download - OLE DB Driver SQL Server 2017  (As of August 2018)

Download - ODBC Driver SQL 2017  (As of August 2018)

 De Soto Blog entry - OLE and ODBC driver summary

mfg Klaus