Assistance installing teradata driver on ubuntu server

Connectivity

Assistance installing teradata driver on ubuntu server

I've installed the server version of ubuntu 14.04.

I updated and upgraded base packages.

I downloaded the tdodbc1620__ubuntu_indep.16.20.00.00-1.tar.gz file. I unzipped it.

I attempted to dpkg -i the file, but was missing a dependency. I installed that dependency and then tried again and it appeared to succeed.

I installed the "teradata" package from the conda library.

 

However, when I try to run my python script, i get an error:

 

teradata.api.InterfaceError: ('DRIVER_NOT_FOUND', "No driver found for 'Teradata'. Available drivers: ")

 

I assume this means I did not actually (or correctly) install the driver?

 

Thank you for your help!


Accepted Solutions

Re: Assistance installing teradata driver on ubuntu server

I'm good!

 

I created an .odbc.ini file.

I added the environment variable and an export command to bashrc.

 

Now it works!

 

Thank you!

1 ACCEPTED SOLUTION
6 REPLIES

Re: Assistance installing teradata driver on ubuntu server

It looks like my missing step is configuring the odbc.ini file. I'll work on that and update the thread based on the results.

Re: Assistance installing teradata driver on ubuntu server

I'm good!

 

I created an .odbc.ini file.

I added the environment variable and an export command to bashrc.

 

Now it works!

 

Thank you!

Re: Assistance installing teradata driver on ubuntu server

Hello,

I just have the same problem like you. I've installed ODBC Ubuntu driver 16.20, I created an .odbc.ini file and still not working.

Did you do the same steps. I don't know what's wrong.

 

I've installed the following: 

 

Followed by:

  • Copied .ini files as per these instructions
  • Changed .ini files according to this comment
    • instead of tdata.so used tdataodbc_sb64.so as tdata.so wasn't present
  • add new odbc-related bin and lib folders to $PATH

 

Resulting in the following error:

File "teratest.py", line 6, in <module>
    session = udaExec.connect(method="odbc", system=teradata_server, username="userX", password ="topsecrect")
  File "/home/dsglbiimrecog/.conda/envs/color_venv/lib/python2.7/site-packages/teradata/udaexec.py", line 183, in connect
    **args))
  File "/home/dsglbiimrecog/.conda/envs/color_venv/lib/python2.7/site-packages/teradata/tdodbc.py", line 427, in __init__
    connectParams["DRIVER"] = determineDriver(dbType, driver)
  File "/home/dsglbiimrecog/.conda/envs/color_venv/lib/python2.7/site-packages/teradata/tdodbc.py", line 391, in determineDriver
    "Available drivers: {}".format(dbType, ",".join(drivers)))
teradata.api.InterfaceError: ('DRIVER_NOT_FOUND', "No driver found for 'Teradata'.  Available drivers: ")

 

Thanks in advance

Marc

 

Re: Assistance installing teradata driver on ubuntu server

Did you update bashrc?

 

In your home folder, open .bashrc

 

Then add something like:

 

ODBCINI=$HOME/.odbc.ini

export ODBCINI

 

Except with the location of your ini file if it is different.

Re: Assistance installing teradata driver on ubuntu server

Thanks Emergent for your quick response. Unfortunately this steps doesn't change anything.

Highlighted
Teradata Employee

Re: Assistance installing teradata driver on ubuntu server

If you want to use the entries from your ODBC ini file, use DSN= parameter instead of system=, or just pass a single positional parameter to the connect method containing the name of the DSN. Especially if you are not using a DSN, you may also need to export ODBCINST environment variable pointing to your odbcinst.ini file.