[Microsoft][ODBC Driver Manger] Data source name not found and no default driver specified
15-Jan-1313 Leave a comment
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