'[08001][TPT] [ODBC SQL Server Wire Protocol driver] Invalid connection Data
<p>I have a python program that implies connecting to a teradata database. The server name is defaulted. Two people can succesfully use the python program but one person can't and gets the following error message:</p>

<pre><code>'[08001][TPT]  [ODBC SQL Server Wire Protocol driver] Invalid connection Data
., [TPT][ODBC SQL Server Wire Protocol driver ]Invalid attribute in connection string : DBCNAME.'
</code></pre>

<p>The person who gets the error message has access to that server and uses Teradata.</p>

<p>Python code:</p>

<pre><code>import teradata

udaExec = teradata.UdaExec (appName="test", version="1.0",
            logConsole=False)
session = udaExec.connect(method="odbc", system=servername,username=user1, password=passw)
</code></pre>

<p>If you check the log you can see that probably you have more than one driver for Teradata set into your ODBC configuration.</p>

<p>To set your correct Teradata driver you can add driver property to connect method:</p>

<pre><code>session = udaExec.connect(method="odbc", system="servername", username=user1, password=passw, driver="Teradata");
</code></pre>

<p>A different way to connect to Teradata could be using a DSN defined by user in ODBC settings:</p>

<pre><code>import teradata

udaExec = teradata.UdaExec (appName="test", version="1.0", logConsole=False)
session = udaExec.connect(method="odbc", dsn="&lt;dsn-defined-by-user&gt;", username=user1, password=passw)
</code></pre>

python teradata