Error ORA-28534 when communicating to the IM-server through ODBC
When trying to get information out of the IM-server through ODBC, the error we get is ORA-28534 - Heterogeneous Services preprocessing error.
The query done by the third party software is:
SELECT LOGNAME, QUALITY, DATAVALUE, TIMESTAMP FROM numericlog WHERE LOGNAME in (‘TI520E01:IOPar.IO.Value’) and TIMESTAMP between ‘2021/03/11 10:14:24’ and ‘2021/03/11 10:24:24’
Probably the strings in the query are not correctly converted to a date-time.
The region format setting is English-United States.
According to http://psoug.org/oraerror/ORA-28534.htm the capability table settings need to be checked, but where can I find these settings?
Or is there another problem?
(The ABB_ODA ODBC connection is working)
This question has not yet been answered.