New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
ODBC connection errors #89
Comments
PyTd is expecting to load the ODBC Driver Manager library not the Teradata ODBC Driver library. Looks like you are providing the Teradata OBDC Driver path for odbcLibPath which does not implement the SQLDrivers function. What is the error you get when you don't specify the odbcLibPath and what do the logs show? Here is what my logs show with it working:
|
Hey thanks for answering so quickly. Even if I were to run from teradata import tdodbc
conn = tdodbc.connect() I get the same exact error. Not sure what other odbc driver I could install? iODBC? Stupid question, but how do I find the logs for these commands? Can you suggest any other changes to my .ini files and ENV variables, are they pointing to haphazard or wrong things? |
You typically shouldn't access the tdodbc submodule directly but instead should use the UdaExec wrapper that sets up the logging context. Logs will print directly to console by default and to a file in a logs directory local to the working directory. E.g.
iODBC use to be installed by default on OS X but maybe that has changed. Definitely recommend using iODBC Driver Manager. The Teradata ODBC driver 16.20 documentation states:
|
OS: macOS 10.13.2
Python: 2.7.14
Teradata ODBC Driver for Mac OS X: 16.20.00.0006
unixodbc: Not installed
I am able to test a successful connection using the following operations on command line:
However, when I try to use the Python functionality I get nowhere. Even without any arguments into
tdodbc.connect()
it is the same error.Environment Variables set in ~.zshrc (same as ~.bash_profile)
ODBC.ini
Location: ~/Library/ODBC/odbc.ini
ODBCINST.ini
Location: ~/Library/ODBC/odbcinst.ini
ODBC.ini file in Teradata Directory:
Location:/Library/Application Support/teradata/client/16.20/odbc/odbc.ini
ODBCINST.ini file in Teradata Directory:
Location:/Library/Application Support/teradata/client/16.20/odbc/odbcinst.ini
ODBCINST.ini file in the generic Teradata Directory:
Location: /Library/Application Support/teradadata/client/ODBC/odbcinst.ini
The text was updated successfully, but these errors were encountered: