I need to access TD (12) using MS Access and/or Excel. My login user name is configured to use ldap for authentication. ODBC version is 220.127.116.11.
A. MS Excel 2007: The connection steps seem to work smoothly until it displays the list of available TD tables. Then, it displays the ODBC connection dialogue. After entering the authentication details, which I use successfully with TD SQL Assistant, I get the following consecutive error messages. 1. [NCR][ODBC Teradata Driver][Teradata Database] The UserID, Password or Account is invalid. 2. After pressing OK on the above dialogue, the following comes up: [NCR][ODBC Teradata Driver] Unable to logon with Authentication Mechanism selected.
Note: The connection string, which is generated by MS Excel follows (where xxx is my userID and yyy is my password). DSN=02_Teradata_DevB;UID=abdeenb; AUTHENTICATION=ldap;AUTHENTICATIONPARAMETER=xxx@@yyy ;
B. MS Access 2007: External Data --> More --> ODBC Database --> Import --> ODBC connection dialogue. After entering the authentication details, which I use successfully with TD SQL Assistant, I get the following error message. Error in Procedure: Build Reports - data Error Number: 3151 Error Description: ODBC--connection to '00_Teradata_Prod' failed.
Note: the Connection String used: Public Const sConn As String = "ODBC;DSN=00_Teradata_Prod;UID=wongat;PWD=Burwood54;TLO=0;"
Teradata Version: RELEASE 12.00.03.28_cba VERSION 12.00.03.28.dr144229.d145063