Access / OleDB / ODBC - New seperate driver for SQL 2017 necessary


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

 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