Error while connecting Teradata using python .

Connectivity

Error while connecting Teradata using python .

Hi ,

I am getting below error while connecting to Teradata using python.

 

File "C:\Python27\Lib\site-packages\hello.py", line 5, in <module>
session = udaExec.connect(method="odbc", system="**bleep**",username="**bleep**", password="**bleep**!");
File "C:\Python27\Lib\site-packages\teradata\udaexec.py", line 183, in connect
**args))
File "C:\Python27\Lib\site-packages\teradata\tdodbc.py", line 427, in __init__
connectParams["DRIVER"] = determineDriver(dbType, driver)
File "C:\Python27\Lib\site-packages\teradata\tdodbc.py", line 391, in determineDriver
"Available drivers: {}".format(dbType, ",".join(drivers)))
InterfaceError: ('DRIVER_NOT_FOUND', "No driver found for 'Teradata'. Available drivers: SQL Server,Microsoft ODBC for Oracle,Microsoft Access Driver (*.mdb),Microsoft Access-Treiber (*.mdb),Driver do Microsoft Access (*.mdb),Microsoft dBase Driver (*.dbf),Microsoft dBase-Treiber (*.dbf),Driver do Microsoft dBase (*.dbf),Microsoft Excel Driver (*.xls),Microsoft Excel-Treiber (*.xls),Driver do Microsoft Excel(*.xls),Microsoft Paradox Driver (*.db ),Microsoft Paradox-Treiber (*.db ),Driver do Microsoft Paradox (*.db ),Microsoft Text Driver (*.txt; *.csv),Microsoft Text-Treiber (*.txt; *.csv),Driver da Microsoft para arquivos texto (*.txt; *.csv),Microsoft Visual FoxPro Driver,Microsoft FoxPro VFP Driver (*.dbf),Microsoft dBase VFP Driver (*.dbf),Microsoft Visual FoxPro-Treiber,Driver para o Microsoft Visual FoxPro,SQL Server Native Client 10.0")

 

Code that i have used to connect is below :

import teradata
import pyodbc
udaExec = teradata.UdaExec (appName="HelloWorld", version="1.0",
logConsole=False)
session = udaExec.connect(method="odbc", system="**bleep**",username="**bleep**", password="**bleep**");

2 REPLIES
Teradata Employee

Re: Error while connecting Teradata using python .

Did you install the Teradata ODBC Driver?

Re: Error while connecting Teradata using python .

when i am trying to install odbc driver for teradata . I am getting warning message compatible version of Teradata Gss Client is not installed.ODBC driver for Teradata requires

Teradata Gss client nt x8664 16.00. But i have already installed Teradata Gss Client .I am not able to understand why this warning message is popued up when i try to install ODBC driver .I would be grateful to you if you can help me on this.