Excel 2013 (32 bit ODBC) - Teradata ODBC Connectivity issue using integrated security

Database
Enthusiast

Excel 2013 (32 bit ODBC) - Teradata ODBC Connectivity issue using integrated security

Hi, I have an excel that connectes to Teradata using integrated security method.  It works for mist of the users but some of them get an error - not enough information to connect to Teradata. If I change the code to use standard connection string using UID/PWD, it works for all w/o issues.

 

We all have TD ver 15.0 but some have 32 bit ODBC driver and others have both 32 and 64 bit ODBC installed.  

 

The code I am using:

strConnection = "SessionMode=Teradata;Driver=Teradata;Trusted_connection=yes; DBCName= DBCName.com"