Unable to connect Teradata using Python 3.6.4 |Anaconda, Inc.

[vedbeau]

Hi,
i'm getting below error while connecting teradata from python.
In the below error,i'm getting Available drivers: BLANK
I Installed the driver,but its not recognizing.

Please help

session = udaExec.connect("Teradata ODBC DSN");
2018-05-16 05:24:50,820 - teradata.udaexec - INFO - Creating connection: {'method': 'odbc', 'charset': 'UTF8', 'authentication': 'LDAP', 'system': 'tdsitcop1.us.dell.com', 'username': 'ravina', 'password': 'XXXXXX', 'externalDSN': 'Teradata ODBC DSN'}
2018-05-16 05:24:50,821 - teradata.tdodbc - INFO - Loading ODBC Library: libodbc.so
2018-05-16 05:24:50,822 - teradata.tdodbc - INFO - Available drivers:
2018-05-16 05:24:50,822 - teradata.udaexec - ERROR - Unable to create connection: {'method': 'odbc', 'charset': 'UTF8', 'authentication': 'LDAP', 'system': 'tdsitcop1.us.dell.com', 'username': 'ravina', 'password': 'XXXXXX', 'externalDSN': 'Teradata ODBC DSN'}
Traceback (most recent call last):

[escheie]

Are the ODBCINI or ODBCINST environment variables set to tell the libodbc.so Driver Manager where to locate either the odbc.ini or odbcinst.ini files that point to the Teradata ODBC Driver?

[vedbeau]

Thanks For the update.
ODBCINI is set

[root@ddlpldst101 ~]# echo $ODBCINI
/opt/teradata/client/16.20/odbc_64/odbc.ini
[root@ddlpldst101 ~]#
snippet from python

session = udaExec.connect("Teradata ODBC DSN")
2018-05-17 01:42:22,429 - teradata.udaexec - INFO - Creating connection: {'method': 'odbc', 'charset': 'UTF8', 'authentication': 'LDAP', 'system': 'tdsitcop1.us.dell.com', 'username': 'ravina', 'password': 'XXXXXX', 'externalDSN': 'Teradata ODBC DSN'}
2018-05-17 01:42:22,429 - teradata.tdodbc - INFO - Loading ODBC Library: libodbc.so
2018-05-17 01:42:22,430 - teradata.tdodbc - INFO - Available drivers: ODBC Drivers, Teradata Database ODBC Driver 16.20
2018-05-17 01:42:22,431 - teradata.udaexec - ERROR - Unable to create connection: {'method': 'odbc', 'charset': 'UTF8', 'authentication': 'LDAP', 'system': 'tdsitcop1.us.dell.com', 'username': 'ravina', 'password': 'XXXXXX', 'externalDSN': 'Teradata ODBC DSN'}
Traceback (most recent call last):
File "/opt/anaconda3/lib/python3.6/site-packages/teradata/udaexec.py", line 183, in connect
**args))
File "/opt/anaconda3/lib/python3.6/site-packages/teradata/tdodbc.py", line 454, in init
checkStatus(rc, hDbc=self.hDbc, method="SQLDriverConnectW")
File "/opt/anaconda3/lib/python3.6/site-packages/teradata/tdodbc.py", line 231, in checkStatus
raise DatabaseError(i[2], u"[{}] {}".format(i[0], msg), i[0])
teradata.api.DatabaseError: (0, '[I] [. Check that the ODBC driver is installed and the ODBCINI or ODBCINST environment variables are correctly set.')

[escheie]

Can you try passing the odbcLibPath="/opt/teradata/client/ODBC_64/libodbc.so" argument to the UdaExec constructor? It looks like it may be trying to use UnixODBC.

udaExec = teradata.UdaExec (appName="HelloWorld", version="1.0", odbcLibPath="/opt/teradata/client/ODBC_64/lib/libodbc.so")

[vedbeau]

That works!!!.
Instead of passing the odbclibpath ,how can we overcome or how to set ?
Thanks a lot for your support.

[escheie]

You can set it in a /etc/udaexec.ini file so that it becomes the default for all users on the system. E.g.

[CONFIG]
odbcLibPath=/opt/teradata/client/ODBC_64/lib/libodbc.so