如何使用python连接到Teradata。我正在使用teradatasql包，但遇到错误

Question

我正在尝试使用teradatasql模块连接到teradata。但获取连接被拒绝错误。我正在使用相同的以下代码。有没有什么方法可以连接到teradata来进行同样的操作。

connection = td.connect(host="abc.**.**.com", user="user_id", password="**********")

错误：

teradatasql.OperationalError: [Version 17.0.0.2] [Session 0] [Teradata SQL Driver] Failed to         connect to abc.**.**.com
 at gosqldriver/teradatasql.(*teradataConnection).makeDriverError TeradataConnection.go:1101
 at gosqldriver/teradatasql.newTeradataConnection TeradataConnection.go:164
 at gosqldriver/teradatasql.(*teradataDriver).Open TeradataDriver.go:32
 at database/sql.dsnConnector.Connect sql.go:600
 at database/sql.(*DB).conn sql.go:1103
 at database/sql.(*DB).Conn sql.go:1619
 at main.goCreateConnection goside.go:275
 at main._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 dial tcp 14.167.77.56:775: connect: connection refused

有人能帮我这个忙吗。提前谢谢。

Answer 1

代码应该是，

import teradatasql
import pandas as pd
with teradatasql.connect(host='your_host_name', user='your_user_name', password='*******', logmech = "LDAP", encryptdata='true') as connect:  
  data = pd.read_sql(query, connect)
print(data.head())

这对我很有效。

Answer 2

import teradatasql
import pandas as pd
with teradatasql.connect(host='your_host_name', user='your_user_name', password='*******') as connect:
   data = pd.read_sql('select * from your_table_name;', connect)
print(data.head())

尝试上面的代码行，这可能会对你有所帮助。