I was dealing with this problem earlier today with SQL Server 2017. The ODBC driver didn't seem to matter as I would have spotty connection issues (some would timeout others would work just fine). Setting it to use the IP Address instead of the hostname in the ODBC connection string worked.