Page 1 of 1

syntax error at or near "{"

Posted: Tue 01 Aug 2017 17:35
by ttistlouis
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
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?

Re: syntax error at or near "{"

Posted: Fri 04 Aug 2017 07:09
by azyk
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.