I'm connecting to teradata in python using the pyodbc module, and I keep getting this error. Anyone knows why? I'm using the below code:
import textwrap
import pyodbc
import teradata
import pandas as pd
cnx_tera = ('DRIVER={/Library/Application Support/teradata/client/16.20/lib/tdataodbc_sbu.dylib};'
....)
cnx = pyodbc.connect(cnx_tera)
I was facing a similar problem. Did resolve this problem using the Teradatasql package instead of ODBC, it's very simple to connect using teradatasql. Just put in the right parameters while setting up the connection for teradatasql.
P.S.= Comment for future reference.
pyodbc.Error: ('HY000', '[HY000] [Teradata][ODBC] (11560) Unable to locate SQLGetPrivateProfileString function. (11560) (SQLDriverConnect)')