'pyodbc.Error: ('HY000', '[HY000] [Teradata][ODBC] (11560) Unable to locate SQLGetPrivateProfileString function. (11560) (SQLDriverConnect)')

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)

python-3.xmacosodbcteradatapyodbc


Solution 1:[1]

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.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Kanishk Jadhav

Related Questions