how to connect dataset in matlab?
2 views (last 30 days)
Show older comments
when executing the code given below i am getting the following error:
cannot connect database [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
Here is the code:
conn = database('con', '', '');
disp('cannot connect database')
return; %stop running
sqlquery = 'select * from cust';
decA = exec(conn, sqlquery);
decA = fetch(decA);
Friedrich on 29 Aug 2014
this indicates a bittedness missmatch between MATLAB and your ODBC driver. I guess you use a 64bit MATLAB but have a 32bit ODBC driver installer. Either use a 32bit MATLAB or install a 64bit ODBC driver and use the native "database.ODBCConnection" connection (new feature since 14a).
More Answers (0)
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!