You can translate the question and the replies:

ODBC connection for Denodo 5.5 on Windows Server 2016

Hi Team, Does Denodo 5.5 supports an ODBC connection on Windows Server 2016 ? Getting below error: ERROR: Syntax error: Exception parsing query near 'show' What could be the problem? Driver issue ? Driver Used: postgresql ANSI ODBC driver 64 bit Please help. Thanks.
user
17-07-2019 07:03:02 -0400
code

3 Answers

Hi, I have been able to connect to Denodo (in my case, through Excel client, using instructions mentioned [here](https://community.denodo.com/tutorials/browse/basics/4connect2odbcclient)) and get the data with the ODBC driver. However, I was able to reproduce the issue with the same error as yours when I edited the query just before the data gets imported. For example, the query which is working fine is 'SELECT * FROM view_name'. The query post edit which I executed to reproduce the error is 'SHOW * FROM view_name'. I would recommend that you check the query that is being executed in your client to fetch the data. It is also worth noting that Denodo provides some very good options for fine-tuning the default logging capabilities. You can refer to [Using logcontroller and useful log categories](https://community.denodo.com/kb/view/document/Using%20logcontroller%20and%20useful%20log%20categories?category=Operation) for more information. Hope this helps!
Denodo Team
18-07-2019 07:31:21 -0400
code
Hi Team, We are encountering the error while creating ODBC data source in Windows server 2016. We are not able to create the ODBC DS. ERROR: Syntax error: Exception parsing query near ‘show’ Driver Used: postgresql ANSI ODBC driver 64 bit Please help. Thank
user
18-07-2019 08:16:18 -0400
Hi, I would recommend you to check the ODBC driver's compatibility with your database. If you are using connection type DSN, you need to configure the DSN on the Windows ODBC data source administration tool with the correct driver. You can also test whether this connection is successful or not in the Windows ODBC tool itself, before using it in Denodo ODBC data configuration. Once these two steps are complete, you could check whether you have configured the data source right by referring to [ODBC Sources](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/odbc_sources/odbc_sources) and test the connection. Hope this helps!
Denodo Team
25-07-2019 09:11:26 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here