Teradata ODBC driver on MAC


Teradata ODBC driver on MAC

After installing ODBC driver 15.10 (tried 15.00 too) on a MAC, I tried to connect to a Teradata server and got the following error.

u'[28000] [Teradata][ODBC Teradata Driver][Teradata Database] The UserId, Password or Account is invalid. '

I've tried a few approaches but none of them could connect. Would appreciate it if someone could help ...

   - Teradata Python module, got the above error

   - iODBC demo, the same (above) error from [native ODBC]

   - tdxodbc (from 15.00), SQLConnect could connect, SQLDriverConnect cause segfault (no clues found in dtruss output)

   - adhoc (from 15.10 Sample directory), same as tdxodbc (not surprising since they might be the same code anyways)


Here are the machine and set up information.

$uname -a

Darwin XXXXXX 14.4.0 Darwin Kernel Version 14.4.0: Thu May 28 11:35:04 PDT 2015; root:xnu-2782.30.5~1/RELEASE_X86_64 x86_64 

$cat /Library/ODBC/odbcinst.ini

[ODBC Drivers]

Teradata = Installed


Driver = /Library/Application Support/teradata/client/ODBC/lib/tdata.dylib

Setup  = /Library/Application Support/teradata/client/ODBC/lib/TeradataODBCSetup.bundle/Contents/MacOS/TeradataODBCSetup

$cat ~/Library/ODBC/odbc.ini


Trace         = 1

TraceAutoStop = 0

TraceFile     = /tmp/dmtrace.log

TraceLibrary  = 

[ODBC Data Sources]

TDPROD  = Teradata


Driver          = /Library/Application Support/teradata/client/ODBC/lib/tdata.dylib

DBCName         = TDPROD

Description     = TDPROD

MechanismName   = LDAP

Username        = myusername

Tags (3)
New Member

Re: Teradata ODBC driver on MAC

Did you ever solve this?  I have run into similar issue  -  after getting RODBC, iODBC, Teradata ODBC driver working.