Does the Database Toolbox work also with Wonderware Historian Database on MS SQL Server?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (1)
Prateek Khandelwal
le 3 Jan 2017
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 commentaires
Voir également
Catégories
En savoir plus sur Database Toolbox dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!