Does the Database Toolbox work also with Wonderware Historian Database on MS SQL Server?

2 次查看（过去 30 天）
Roland Mitter
Roland Mitter 2016-12-28
回答： Prateek Khandelwal 2017-1-3
Attached you can find a sql file (I saved it as txt file just for upload!) that works on the server itself, but not when using runsqlscript. It does not get any data. I have of course tested the connection and it works perfectly. It seems there is a problem with complex queries that are using the historian table (?!).
Please - does anyone have experience with Matlab and Wonderware Historian?
Kind regards, Roland

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

回答（1 个）

Prateek Khandelwal
Hi Roland.
Can you please elaborate on how you tested the connection ? And does the same query work if you push it through a client ?
I would also like to point you to the limitations of the runsqlscript, for one, un-escaped apostrophes may lead to unexpected results. I would suggest to test out the function `runsqlscript` by incrementally increasing the complexity of the SQL query you are pushing. This would help identifying the specific construct that is creating the trouble.
Regards.

类别

在 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