MATLAB: Conn.Message gives this error: ‘ODBC Driver Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified’

Database Toolbox

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

Best Answer

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

Related Solutions

MATLAB: Access Apache Hive using ODBC driver

I've tested Hive access via JDBC Driver, but not ODBC Driver yet, but I think possibly, yes.

First, 64 bit ODBC Driver is requied.

Next, configure ODBC data source in Database Toolbox. And I think you can access to Hive

datasource = 'Hive'; % The name of datasource specified in configureODBCDataSource
username = 'XXX';
password = 'YYY';
conn = database(datasource, username, password);
selectquery = 'SELECT TOP 10 * FROM TABLENAME';
data = select(conn,selectquery);

Ref: https://www.mathworks.com/help/database/ug/database.html#btcofz6

MATLAB: Is the ODBC driver slower than the JDBC driver when used with the Database Toolbox

This change has been incorporated into the documentation in Release 14 Service Pack 3 (R14SP3). For previous releases, read below for any additional information:

When you use a ODBC driver, all of your data has to be moved from MATLAB, to Java, to C/C++, and the other way around. If you use a JDBC driver, your data is only moved between Java and MATLAB, and the other way around. Therefore, you will likely experience better results by using a JDBC driver if one is available.

Best Answer

Related Solutions

MATLAB: Access Apache Hive using ODBC driver

MATLAB: Is the ODBC driver slower than the JDBC driver when used with the Database Toolbox

Related Question