Matlab fetch function freezes Matlab, even with limited rows in the fetch request.

4 次查看（过去 30 天）
Iris
Iris 2023-2-9
回答： Nikhil 2023-2-23
Hi,
I'm using Matlab 2017A and the code keeps getting stuck on fetching data from a SQL 'view'. It is possible to connect to the database and to retrieve data from other Tables, but not from the table in the 'Views' folder in Microsoft SQL Server.
I don't get an error message, the code just keeps loading forever and makes Matlab freeze.
Can you help me pinpointing the reason for this behaviour?
Thanks,
Iris

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

回答（1 个）

Nikhil
Nikhil 2023-2-23
Hi Iris,
Have you tried any other functions than fetch ? If not, have a look at the following functions which server the same purpose.
sqlread : https://www.mathworks.com/help/database/ug/database.odbc.connection.sqlread.html
select : https://www.mathworks.com/help/database/ug/database.odbc.connection.select.html
executeSQLScript : https://www.mathworks.com/help/database/ug/database.odbc.connection.executesqlscript.html
Hope this helps.

类别

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

标签

产品


版本

R2017a

Community Treasure Hunt

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

Start Hunting!

Translated by