Matlab fetch function freezes Matlab, even with limited rows in the fetch request.
2 views (last 30 days)
Show older comments
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?
Nikhil on 23 Feb 2023
Have you tried any other functions than fetch ? If not, have a look at the following functions which server the same purpose.
executeSQLScript : https://www.mathworks.com/help/database/ug/database.odbc.connection.executesqlscript.html
Hope this helps.
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!