how to connect dataset in matlab?

Question

Waqas 2014-8-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/152755-how-to-connect-dataset-in-matlab

回答： Friedrich 2014-8-29

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Friedrich 2014-8-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/152755-how-to-connect-dataset-in-matlab#answer_150168

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