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