You can translate the question and the replies:

ODBC DSN connection error

Hello, I'm using Denodo Express 8.0 and trying to configure DSN for ODBC connections, but getting weird error went trying to test it (image attached). All ports are default. ODBC driver is installed from <DENODO_HOME>/tools/client-drivers/odbc. **ERROR: Connection error: Check the host name and port number are correct, and that client and server belong to the same Denodo major version. Permission denied : no further information: /0.0.0.0:9999 DETAIL: java.SQLException" Connection error: Check the host name and port number are correct, and that client and server belong to the same Denodo major version. Permission denied : no further information: /0.0.0.0:9999 ** I'm able to ping the server successfully though (as well as connect to database and create/execute views): https://ibb.co/W5d7cp0 Can you please help in understanding the issue nature and how to resolve it?
ODBC DSN Error
user
15-04-2021 08:46:41 -0400
code

2 Answers

Hi, In order to successfully configure ODBC connection to Virtual DataPort server, I would perform the following checks: * Make sure that you have selected the DenodoODBC Unicode driver while creating the DSN. * Check if there are no other process running on default ODBC port(9996). * If I have Denodo Platform configured with SSL, I would make sure to set the SSL Mode to required in the ODBC connection. You can refer to the Knowledge Base article [DSN configuration for ODBC connections to VDP](https://community.denodo.com/kb/view/document/DSN%20configuration%20for%20ODBC%20connections%20to%20VDP?category=Northbound+Connections) to get more information. You can also refer to this similar [Community Q&A](https://community.denodo.com/answers/question/details?questionId=9064u000000CeoEAAS&Unable+to+Connect+to+VDP+via+ODBC+drivers) for more information. Hope this helps!
Denodo Team
16-04-2021 04:16:53 -0400
code
Hi, I face the same issue. Disabled the ssl mode. Changed the odbc port from 9996 to 9876 in the conf file. What's wrong ? KR, Laurent
user
19-02-2024 05:42:00 -0500
You must sign in to add an answer. If you do not have an account, you can register here