[Microsoft][ODBC Driver Manger] Data source name not found and no default driver specified

ERROR

Have an old Excel file that connects to a database list using Microsoft Query. An existing user was moved to a new Windows 7 machine and then got this error.

[Microsoft][ODBC Driver Manger] Data source name not found and no default driver specified

SOLUTION

Tried various things. In the end.

In Administrative Tools > ODBC > Drivers on his machine SQLNCLI was missing.
I did not want to install this old version, so initially changed the connection string to “SQL Server Native Client 10.0” but “SQLNCLI10” may work