Results 1 to 3 of 3

Thread: TeradataAttunity Driver - SSIS connection error - SQLState -IM003

  1. #1
    premsamuel is offline Junior Member
    Join Date
    Jun 2012
    Posts
    2
    Rep Power
    0

    TeradataAttunity Driver - SSIS connection error - SQLState -IM003

    I was able to successfully install Attunity 64bit drive on SQL 2008 R2 and Windows 2003 server. But when testing the SSIS connection I am seeing the following error message

    Error at Package [Connection manager "TeradataAttunity"]: There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server. SqlState =IM003 Message = Specified driver could not be loaded due to system error 126 (Teradata)

    Test connection failed.

    Any help appreciated ? Thanks,

  2. #2
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    Hi,

    If you have the proper ICU and GSS packages installed, make sure you restart the machine after installing the Teradata ODBC driver.


    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    premsamuel is offline Junior Member
    Join Date
    Jun 2012
    Posts
    2
    Rep Power
    0
    yes, I do have ICU and GSS installed. After the installation, I bounced the server.



    Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •