Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
Link copied. Please paste this link to share this article on your social media post.
Hello,
we want to retreive data from GeoSCADA DB making queries in SQL format, through OLE DB GeoSCADA driver.
We configured properly the connection from our application, which allow to query system using SQL statements, to GeoSCADA Server (see attached screenshot).
When we try to test any kind of query we receive the error attached in the picture. We also tried queries that works if wrote directly in the Geoscada server.
Do you know how this can be solved?
thank you,
best regards
Link copied. Please paste this link to share this article on your social media post.
Try unticking the "Test with TOP 100" box.
You could have a look in the GeoSCADA Expert Server Status to see what the query actually looks like that's getting to the server. I can't recall if I've ever used it to check on invalid queries, so it's possible that it doesn't show up there. But you can probably configure the logs to show you something.
Line 1, Col 12 doesn't appear to be a boundary within your as-written query... so I suspect something is altering it before it is sent to the server.
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.