MSTERA Connection Manager and ODBC (x86) Issues after VS17SSDT15/Attunity5/Teradata 16.2 Upgrade

• quinn.jay

  SSCertifiable

  Points: 5505

  More actions

  October 19, 2018 at 8:19 am

  #416209

  Hello,
  Nnow that I have installed and upgraded to Teradata 16.2 driver and utilities (32/64 bit), and installed Attunity 5 for Teradata, and Visual Studio 2017 w/ SSDT 15…

  I go to open a SSIS package, expecting to get errors as I do about the Connection Manager. I go to create a new connection manager, and I get this error when testing:

  "Failed to establish an ODBC connection with the database server. Verify that the Teradata ODBC Driver for Windows x86 is installed properly. SqlState = IM002 Message = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

  I have gone through both 32 and 64 bit ODBC managers, and the Teradata drivers are there, in User, File and DDN set up. I can also see, and select MSTERA when I go to create the Connection Manager.

  I’ve also tried to set the 32/64 bit in the packages debug, and that change doesn’t make any progress, I get the same error. I left VS15 and its SSDT 14 in place, along with Attunity 4, and do all the same attempted changes there and also get the same exact error messages.

  What am I missing? What else can I try?
  
  Thank you

• Phil Parkin

  SSC Guru

  Points: 246990

  More actions

  October 19, 2018 at 8:24 am

  #2010441

  Duplicate post. See here.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel