How to resolve pythonodbc issue with teradata in ubuntu?

@elisha_langworth 

To resolve pythonodbc issues with Teradata in Ubuntu, you can try the following steps:

1. Make sure you have the necessary dependencies installed by running the following command:

1

sudo apt-get install unixodbc unixodbc-dev freetds-dev freetds-bin tdsodbc

1. Install the Teradata ODBC driver for Linux by downloading it from the Teradata website and following the installation instructions provided.
2. Set up a Data Source Name (DSN) for Teradata in the odbc.ini file located in /etc directory. Add the following lines to the odbc.ini file:

1
2
3
4
5
6

[YourDSNName]
Driver=/path/to/teradata/odbc/driver/lib/libteradataodbc.so
Description=Teradata ODBC Driver
DBCName=YourTeradataServer
UID=YourUsername
PWD=YourPassword

1. Test the ODBC connection by running the following command:

1

isql -v YourDSNName

You should be able to connect to the Teradata server using the credentials provided.

1. Install the pyodbc package in your Python environment by running:

1

pip install pyodbc

1. Use the following code to connect to Teradata using pyodbc in your Python script:

1
2
3
4
5
6

import pyodbc
conn = pyodbc.connect('DSN=YourDSNName')
cursor = conn.cursor()
cursor.execute('SELECT * FROM YourTable')
for row in cursor:
    print(row)

By following these steps, you should be able to resolve pythonodbc issues with Teradata in Ubuntu and successfully connect to the Teradata server using pyodbc.