how to connect dataset in matlab?

9 次查看（过去 30 天）
Waqas
Waqas 2014-8-29
回答： 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);

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

采纳的回答

Friedrich
Friedrich 2014-8-29
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by