syntax error at or near "{"

syntax error at or near "{"

Postby ttistlouis » Tue 01 Aug 2017 17:35

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?
Posts: 1
Joined: Tue 01 Aug 2017 16:24

Re: syntax error at or near "{"

Postby azyk » Fri 04 Aug 2017 07:09

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.
Devart Team
Posts: 979
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Return to ODBC Drivers