Why do i get {'No Data'} from large SQL query?

6 次查看（过去 30 天）

Daniel Wesch 2017-8-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/353906-why-do-i-get-no-data-from-large-sql-query

评论： Sailesh Sidhwani 2017-8-30

Hi,

I have a large SQL query string (6481 chars), which i have succesfully converted into a Matlab string. Sucessfully, since copying the string and inserting it into SQL Management Studio yields the correct table.

Now, retrieving the data through Matlab's database tools yields a 1x1 cell containing the string 'No Data'.

I've done hundreds of queries through the database tool, so I fail to see how this differs - the query is a bit more complicated than usual, but surely this should have no effect.

I'm aware it's a bit hard to troubleshoot, since it can't be reproduced, but please point me in the (a) right direction.

The server is running on Windows NT 6.3 (9600), 64 bits and the driver is ODBC.

With Microsoft SQL Server Enterprise V. 12.0.5000.0.

I'm using MATLAB R2016b.

Thanks!

3 个评论
显示 1更早的评论隐藏 1更早的评论

Daniel Wesch 2017-8-24

Yeah, I know, which is why I already flagged that. I had hoped that there might be some relatively known, generic problem.

In a nutshell, the problem is that the string works in SQL mgmt, but doesn't through the Matlab database tool.

Sailesh Sidhwani 2017-8-30

Hi Daniel,

If possible you can try switching to the JDBC driver and see if that resolves the issue. Also, following is link of common error with fetching data in MATLAB: https://www.mathworks.com/help/database/ug/fetching-data-common-errors.html

请先登录，再进行评论。

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