Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X
Hello everyone!
Testing ADO Service, I encountered the following problem. Having created a new service of SQL-query type I try to make a SELECT — but any of the written options leads to this:
Is the problem in the wrong team or the table is considered generally empty? Judging by the IsConnected property set to true and the screenshot below, ThingWorx sees the tables and columns of my database.
Solved! Go to Solution.
I found the solution. The command format was incorrect. The correct option is:
SELECT * FROM "<Table Name>$"
Hi @Mr_Henry_M.
Are you actually connecting to a database or a spreadsheet, as it appears in your script? This article may help.
Regards.
--Sharon
Hi. Thank you for the answer.
I'm connecting to a spreadsheet, yes. Does it matter? If I understand correctly, Excel is perceived here as a database that can be accessed with queries like any other.
This article is familiar to me. But here we are talking about connecting and connecting problems. I have already passed this stage. The data of my data source is displayed correctly, judging by the script. Therefore, the meaning of Null in the error isn't clear to me.
I found the solution. The command format was incorrect. The correct option is:
SELECT * FROM "<Table Name>$"