title: (DRIVER_NOT_FOUND', "No driver found for 'Teradata'. Available drivers:) - using Anaconda-Jupyter notebooks with teradata module
body: <p>I have been using <em>Anaconda-Jupyter notebooks</em> with <em>python version 3.5.4</em>. The objective was to create the connection string in order to connect the Anaconda-Jupyter notebooks Python with Teradata DB. After installing the <em>teradata python package</em>, I got some error stating that <strong>('<code>DRIVER_NOT_FOUND</code>', "<code>No driver found for 'Teradata'. Available drivers:</code> ")</strong>.</p>
  
  <p>I need this connection string in order to get the tables from the teradata DB along with data. I have already installed ODBC Driver and created an odbc.ini file. But still, I'm getting this Driver not found error Jupiter notebook. Please, help me out. Below is the script, which I'm using for making connection string.</p>
  
  <p>Please let me know to what to be write in system,host,dsn,username,password. and what will be the driver name for teradata database. They need to be mention in this script:</p>
  
  <pre><code>udaExec.connect(method="odbc",system=host, username=username,
                              password=password, driver="DRIVERNAME")
  </code></pre>
  
  <p>PS: The Anaconda-Jupyter Notebook server is running on Unix.</p>
  
  <p><strong>Script:</strong></p>
  
  <pre><code>#Using teradata module
  #You can install teradata via PIP: pip install teradata
  #to get a list of your odbc drivers names, you could do: teradata.tdodbc.drivers
  
  import teradata
  import pandas as pd
  
  host,username,password = 'HOST','UID', 'PWD'
  #Make a connection
  udaExec = teradata.UdaExec (appName="test", version="1.0", logConsole=False)
  
  
  with udaExec.connect(method="odbc",system=host, username=username,
                              password=password, driver="DRIVERNAME") as connect:
  
      query = "SELECT * FROM DATABASEX.TABLENAMEX;"
  
      #Reading query to df
      df = pd.read_sql(query,connect)
  
  # do something with df,e.g.
  print(df.head()) #to see the first 5 rows
  </code></pre>
  
  <p>Thanks!</p>