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

Question

Iris 2023-2-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1909545-matlab-fetch-function-freezes-matlab-even-with-limited-rows-in-the-fetch-request

回答： 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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Nikhil 2023-2-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1909545-matlab-fetch-function-freezes-matlab-even-with-limited-rows-in-the-fetch-request#answer_1178055

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

回答（1 个）

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

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

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

回答（1 个）

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

WeChat

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

0 个评论
显示 -2更早的评论隐藏 -2更早的评论