Does the Database Toolbox work also with Wonderware Historian Database on MS SQL Server?
조회 수: 1 (최근 30일)
이전 댓글 표시
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
댓글 수: 0
답변 (1개)
Prateek Khandelwal
2017년 1월 3일
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.
댓글 수: 0
참고 항목
카테고리
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!