how to connect dataset in matlab?

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

Answer 1

[Friedrich]

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