'Unable to get catalog string error' when using ODBC to connect

Database

'Unable to get catalog string error' when using ODBC to connect

I am trying to reach a remote host that is running Teradata services via ODBC.

My machine is 64-bit RHEL 6.x with the following Teradata software installed:

Media: TTU Foundation

.........................................................

1. bteq      - 14.10.00.03 - Teradata BTEQ Application  

2. fastexp   - 14.10.00.04 - Teradata FastExport Utility

3. fastld    - 14.10.00.04 - Teradata FastLoad Utility    

4. jmsaxsmod - 14.10.00.01 - Teradata JMS Access Module

5. mload     - 14.10.00.04 - Teradata MultiLoad Utility         

6. mqaxsmod  - 14.10.00.01 - WebSphere(r) Access Module for Teradata

7. npaxsmod  - 14.10.00.01 - Teradata Named Pipes Access Module        

8. sqlpp     - 14.10.00.00 - Teradata C Preprocessor              

9. tdodbc    - 14.10.00.02 - Teradata ODBC Driver                 

10. tdwallet  -14.10.00.001 - Teradata Wallet Utility             

11. tptbase   - 14.10.00.02 - Teradata Parallel Transporter Base

12. tptstream - 14.10.00.02 - Teradata Parallel Transporter Stream 

13. tpump     - 14.10.00.04 - Teradata TPump Utility                   

When I try to connect to the remote host via Python, I receive a 'Unable to get catalog string' error:

[@myhost:/path/to/scripts] ->python

Python 2.6.6 (r266:84292, Nov 21 2013, 10:50:32)

[GCC 4.4.7 20120313 (Red Hat 4.4.7-4)] on linux2

Type "help", "copyright", "credits" or "license" for more information.

>>> import pyodbc

>>> pyodbc.pooling = False

>>> cn = pyodbc.connect("DRIVER={Teradata};SERVER=12.245.67.255:1025;UID=usr;PWD=pwd", ANSI = True)

Traceback (most recent call last):

  File "<stdin>", line 1, in <module>

pyodbc.Error: ('28000', '[28000] [Teradata][ODBC Teradata Driver] Unable to get catalog string. (0) (SQLDriverConnect)')

Furthermore, when I try to use isql (from the unixODBC yum package), I receive the same error

[@my_host:/path/to/scripts] ->isql -v proddsn

[28000][Teradata][ODBC Teradata Driver] Unable to get catalog string.

[ISQL]ERROR: Could not SQLConnect


[@my_host:/path/to/scripts] ->isql

**********************************************

* unixODBC - isql                            *

**********************************************

* Syntax                                     *

*                                            *

*      isql DSN [UID [PWD]] [options]        *

*                                            *

* Options                                    *

*                                            *

* -b         batch.(no prompting etc)        *

* -dx        delimit columns with x          *

* -x0xXX     delimit columns with XX, where  *

*            x is in hex, ie 0x09 is tab     *

* -w         wrap results in an HTML table   *

* -c         column names on first row.      *

*            (only used when -d)             *

* -mn        limit column display width to n *

* -v         verbose.                        *

* -lx        set locale to x                 *

* -q         wrap char fields in dquotes     *

* -3         Use ODBC 3 calls                *

* -n         Use new line processing         *

* --version  version                         *

*                                            *

* Commands                                   *

*                                            *

* help - list tables                         *

* help table - list columns in table         *

* help help - list all help options          *

*                                            *

* Examples                                   *

*                                            *

*      isql WebDB MyID MyPWD -w < My.sql     *

*                                            *

*      Each line in My.sql must contain      *

*      exactly 1 SQL command except for the  *

*      last line which must be blank (unless *

*      -n option specified).                 *

*                                            *

* Please visit;                              *

*                                            *

*      http://www.unixodbc.org               *

*      pharvey@codebydesign.com              *

*      nick@easysoft.com                     *

**********************************************

Please advise.