I recognize this may be a specific solution option that may not work for everyone, but the root of the problem is confirmed to be a TCP connection issue from my experience. For example on Windows: C:\WINDOWS\system32>nslookup MYDB-TEST # Īliases: # <- works I am also on a VPN and found that the actual host name in DNS didn't work, but the ALIAS available did. I had this issue today and resolved it by altering my host. The most likely cause is that some kind of networking problem prevented the driver from properly connecting to the database. ![]() In other words, the driver thought that it had established a TCP socket connection, but the TCP socket connection was probably not fully successful, because a failure occurred on the initial message handshake between the driver and the database. The stack trace indicates that a TCP socket connection was made to the database, then the driver transmitted a Config Request message to the database, then the driver timed out waiting for a Config Response message from the database. The root cause of this error is outlined here by tomnolan: _cgoexpwrap_212fad278f55_goCreateConnection _cgo_gotypes.go:240↵ at runtime.call64 asm_amd64.s:574↵ at runtime.cgocallbackg1 cgocall.go:316↵ at runtime.cgocallbackg cgocall.go:194↵ at runtime.cgocallback_gofunc asm_amd64.s:826↵ at runtime.goexit asm_amd64.s:2361↵Caused by read tcp IP:PORT->IP:PORT: wsarecv: An existing connection was forcibly closed by the remote host (*DB).Conn sql.go:1619↵ at main.goCreateConnection goside.go:275↵ at main. Open TeradataDriver.go:32↵ at database/ sql.go:600↵ at database/sql.(*DB).conn sql.go:1103↵ at database/sql. (*teradataConnection).sendAndReceive TeradataConnection.go:1397↵ at gosqldriver/teradatasql.newTeradataConnection TeradataConnection.go:180↵ at gosqldriver/teradatasql.(*teradataDriver). These are the following: OCI, LDAP, Basic, and TNS. (*teradataConnection).makeDriverError TeradataConnection.go:1101↵ at gosqldriver/teradatasql. There are four main ways to connect to Oracle databases using Oracle JDBC drivers. Failure receiving Config Response message header↵ at gosqldriver/teradatasql. Session = nnect(host=host, user=username, password=password, logmech="LDAP") Host, username, password = 'hostname', 'username', '****' The code is running fine on localhost, but once deployed on the server as part of the server code, it is throwing the error. ![]() :) I do not know how to close this thread. Adding below line at the top solved my problem logmech LDAP Problem solved. I am trying to connect to Teradata using teradatasql module in Python. 1 Answer Sorted by: 0 The problem was, I should have mentioned what mechanism I should be using to connect.
0 Comments
Leave a Reply. |