SQL query using OLE DB GeoSCADA driver

[GianlucaBigoni]

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

[BevanWeiss · Accepted solution]

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.

[sbeadle]

Also check your ODBC client is using ODBC v1.0

(See in the ODBC tracing in the Windows ODBC setup)

[GianlucaBigoni · Accepted solution]

Thank you @BevanWeiss and @sbeadle .

At the end, looking to the query logs from GeoSCADA Server, we identified that my application added a ";" at the end of the queries. This doesn't work for GeoSCADA.

We solved adding to the editor query builder of my app a "--" at the end of the query.

Of course we also removed the check on "Select TOP 100".