syntax error at or near "{"

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
ttistlouis
Posts: 1
Joined: Tue 01 Aug 2017 16:24

syntax error at or near "{"

Post by 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
[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?

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: syntax error at or near "{"

Post by 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.

Post Reply