conn.Message gives this error: 'ODBC Driver Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified'

I am connecting to a database with an ODBC driver but receive this error message:

'ODBC Driver Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified'.

This documentation page indicates the error is thrown when the data source name is spelled incorrectly, but I am sure it is spelled correctly.

https://www.mathworks.com/help/database/ug/database-connection-error-messages.html

Answer 1

[MathWorks Support Team]

This error can also occur if the data source was not configured correctly using the ODBC driver. Refer to this documentation page for steps to set up a data source using an ODBC driver. Confirm that the connection is successful when testing the data source:

https://www.mathworks.com/help/database/ug/microsoft-sql-server-odbc-windows.html