环境变量:
export ODBCINI=/opt/teradata/client/16.20/odbc_64/odbc.ini
export ODBCINST=/opt/teradata/client/16.20/odbc_64/odbcinst.ini
export LD_libraRY_PATH=/opt/teradata/client/16.20/odbc_64/lib
import teradata
udaExec=teradata.UdaExec(odbcLibPath="/opt/teradata/client/16.20/odbc_64/lib/libodbc.so",appName="testconnec",version="1.0",logConsole=False)
session = udaExec.connect(method="odbc",dsn="TeraDev",username="user",password="password",driver="Teradata Database ODBC Driver 16.20");
Error:
Traceback (most recent call last):
File "<stdin>",line 1,in <module>
File "/home/hadoop/.local/lib/python2.7/site-packages/teradata/udaexec.py",line 183,in connect
**args))
File "/home/hadoop/.local/lib/python2.7/site-packages/teradata/tdodbc.py",line 454,in __init__
checkStatus(rc,hDbc=self.hDbc,method="SQLDriverConnectW")
File "/home/hadoop/.local/lib/python2.7/site-packages/teradata/tdodbc.py",line 231,in checkStatus
raise DatabaseError(i[2],u"[{}] {}".format(i[0],msg),i[0])
teradata.api.DatabaseError: (0,u'[IM002] [DataDirect][ODBC lib] Data source name not found and no default driver specified')
我在这里错过了任何东西吗? 在这里,我试图连接到Teradata并将一些文件加载到其中。