![]() 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:sybase:User=myuser Password=mypassword Server=localhost Database=mydatabase Charset=iso_1 Īfter establishing a connection, the wizard will close and the connection will be available in the connections panel. Server=MyServer Port=MyPort User=SampleUser Password=SamplePassword Database=MyDB Kerberos=true KerberosKDC=MyKDC KerberosRealm=MYREALM.COM KerberosSPN=server-name Built-in Connection String Designerįor assistance in constructing the JDBC URL, use the connection string designer built into the Sybase JDBC Driver. ![]() You can find an example connection string below: See the Using Kerberos section in the Help documentation for more information on using Kerberos authentication. To leverage Kerberos authentication, begin by enabling it setting AuthScheme to Kerberos. To connect with LDAP authentication, you will need to configure Sybase server-side to use the LDAP authentication mechanism.Īfter configuring Sybase for LDAP, you can connect using the same credentials as Password authentication. Password: Set this to the username of the authenticating Sybase user.User: Set this to the username of the authenticating Sybase user.Set the AuthScheme to Password and set the following connection properties to use Sybase authentication. Sybase supports several methods for authentication including Password and Kerberos. ![]() Optionally, you can also secure your connections with TLS/SSL by setting UseSSL to true.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |