We have a need to connect DocuWare LDC to a Progress Database via ODBC.
Has anybody been able to successfully complete this as we constantly get the below error no matter the query we try -
<exception>DocuWare.Common.Exceptions.DWDBException: ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about "FROM pub.pordhdr" (10713)
Syntax error in SQL statement at or about "FROM "CF"."PUB"."pordhdr" de" (10713)
Syntax error in SQL statement at or about "FROM "pub"."pordhdr"" (10713)
We've tried all the above amendments to the actual query we run but nothing seems to work!
A third party application is running the below query that does work using the same ODBC driver but LDC does not!!! -
SELECT de."total-goods" FROM "CF."PUB"."pordhdr" de