![]() ![]() 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 Create a JDBC Data Source for LDAP Objects. 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). (*teradataConnection).makeDriverError TeradataConnection.go:1101↵ at gosqldriver/teradatasql. 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. You can then query the tables.I am trying to connect to Teradata using teradatasql module in Python. Either double-click the JAR file or execute the jar file from the command-line.įill in the connection properties and copy the connection string to the clipboard.Ī typical JDBC URL is the following: jdbc:teradata:User=myuser Password=mypassword Server=localhost Database=mydatabase Īfter establishing a connection, the wizard will close and the connection will be available in the connections panel. If not specified, the default database is used.įor assistance in constructing the JDBC URL, use the connection string designer built into the Teradata JDBC Driver. Port: Specify the port the server is running on.DataSource: Specify the Teradata server name, DBC Name, or TDPID.Password: Set this to the password of the Teradata user.User: Set this to the username of a Teradata user.To connect to Teradata, provide authentication information and specify the database server name. The JDBC URL begins with jdbc:teradata: and is followed by a semicolon-separated list of connection properties. (This property can also be set in the JDBC URL.) Driver Class: Set the driver class to.Driver Location: Set this property to the path to the lib subfolder in the installation directory.In the Connection Wizard that appears, set the following properties:.Open the RazorSQL application and, in the Connections menu, select Add Connection Profile -> Other -> JDBC.This article shows how to connect to Teradata using wizards in RazorSQL.Ĭreate a JDBC Data Source for Teradata Data The CData JDBC Driver for Teradata enables standards-based access from third-party tools, from wizards in IDEs to data management and analysis tools. The code is running fine on localhost, but once deployed on the server as part of the server code, it is throwing the error. ![]()
0 Comments
Leave a Reply. |