Using Devart ODBC Driver for PostgreSQL version 2.1.5. Client moved database to a different server. Everything worked fine before but after updating the server location in the ODBC settings, there is now the following error
[Devart][ODBC][PostgreSQL]
Description: [HY000] SQL call failed. syntax error at or near "{"
We are not using { in the query, and the query works in pgAdmin. And again, nothing was changed with that part, just the server address.
Any ideas on how to fix this?
syntax error at or near "{"
Re: syntax error at or near "{"
Please provide the SQL query, on which we will be able to reproduce the specified error. Also send us CREATE scripts of the tables used in this SQL query.