You can translate the question and the replies:

Unable to Connect to VDP via ODBC drivers

Hello - I am able to connect no problem via JDBC to VDP (tutorial example). ODBC is not working and getting the below error in configuring the DNS. I am running everything locally on Windows. My ports are all defaults and VDP admin console shows port 9996. For some reason it looks like it cannot resolve localhost even though VDP is working and I can connect to VDP via JDBC connection. hosts file: 127.0.0.1 localhost ::1 localhost Can connect to localhost:port outside using netconnection test as shown below: PS C:\Users\Suntosh Murthy> Test-NetConnection localhost -port 9996 ComputerName : localhost RemoteAddress : ::1 RemotePort : 9996 InterfaceAlias : Loopback Pseudo-Interface 1 SourceAddress : ::1 PingSucceeded : True PingReplyDetails (RTT) : 0 ms TcpTestSucceeded : True ODBC logs show the below: [7508-1218.924]CC_connect: entering... [7508-1218.924]sslmode=prefer [7508-1218.924]reverse lookup=0 [7508-1218.924]LIBPQ_CC_connect: entering... [7508-1218.925]Driver Version='09.03.0600,Apr 16 2020' linking 1600 dynamic Multithread library [7508-1218.927]LIBPQ_CC_connect: DSN = 'tutorial', server = 'localhost', port = '9996', database = 'tutorial', username = 'admin', password='xxxxx', krbsrvname='HTTP' [7508-1218.928]connecting to the database using localhost as the server [7508-1218.928]!!! usrname=admin server=localhost [7508-1218.929]sizeof connectdb option = 147 [7508-1239.953]CC_error_statements: self=000000B22EB16350 [7508-1239.955]CONN ERROR: func=LIBPQ_connect, desc='', errnum=101, errmsg='ERROR: Connection error: Check the host name and port number are correct, and that client and server belong to the same Denodo major version. Connection timed out: no further information: /0.0.0.0:9999 DETAIL: java.sql.SQLException: Connection error: Check the host name and port number are correct, and that client and server belong to the same Denodo major version. Connection timed out: no further information: /0.0.0.0:9999 ' [7508-1239.959]Could not establish connection to the database; LIBPQ returned -> ERROR: Connection error: Check the host name and port number are correct, and that client and server belong to the same Denodo major version. Connection timed out: no further information: /0.0.0.0:9999 DETAIL: java.sql.SQLException: Connection error: Check the host name and port number are correct, and that client and server belong to the same Denodo major version. Connection timed out: no further information: /0.0.0.0:9999 [7508-1239.962]SOCK_Destructor [7508-1239.962]enter CC_get_error [7508-1239.962]enter CC_create_errormsg [7508-1239.962]msg = 'ERROR: Connection error: Check the host name and port number are correct, and that client and server belong to the same Denodo major version. Connection timed out: no further information: /0.0.0.0:9999 DETAIL: java.sql.SQLException: Connection error: Check the host name and port number are correct, and that client and server belong to the same Denodo major version. Connection timed out: no further information: /0.0.0.0:9999 ' [7508-1239.964]exit CC_create_errormsg [7508-1239.965]exit CC_get_error
user
26-08-2020 10:36:17 -0400

1 Answer

Hi, To resolve this issue, I would follow the below steps: * Make Sure that Virtual Data Port server is running. * Make sure that you have selected DenodoODBC Unicode driver while creating the DSN * There is no other process running on port 9996 You may also 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 on this. Hope this helps!
Denodo Team
27-08-2020 02:16:14 -0400
You must sign in to add an answer. If you do not have an account, you can register here