MATLAB Answers

Waqas
0

how to connect dataset in matlab?

Asked by Waqas
on 29 Aug 2014
Latest activity Answered by Friedrich
on 29 Aug 2014
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', '', '');
if(isempty(conn.message))
disp('Database connected')
else
disp('cannot connect database')
disp(conn.message)
return; %stop running
end
sqlquery = 'select * from cust';
decA = exec(conn, sqlquery);
decA = fetch(decA);

  0 Comments

Sign in to comment.

Tags

Products

1 Answer

Answer by Friedrich
on 29 Aug 2014
 Accepted Answer

Hi,
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).

  0 Comments

Sign in to comment.