All Forums Connectivity
seabull 4 posts Joined 01/10
09 Sep 2015
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



You must sign in to leave a comment.