Get Data Moving 1
Results 1 to 3 of 3

Thread: Failed to establish and ODBC connection with the database server after restaged PC

  1. #1
    Beth is offline Junior Member
    Join Date
    Mar 2015
    Posts
    5
    Rep Power
    0

    Failed to establish and ODBC connection with the database server after restaged PC

    My PC was restaged and I've upgraded the versions of Visual Studio to 2017, SSDT to 15.1.xx, SSIS designer to 14.0.xx, TTU:
    Version Display Name
    --------------------------------------------------------------------------------------------------------------------
    14.10.00.03 Teradata Visual Explain 14.10.0.3
    15.10.01.00 Teradata GSS Client nt-x8664 15.10.1
    16.10.0.0 .NET Data Provider for Teradata 16.10
    16.10.00.00 Shared ICU Libraries for Teradata 16.10
    16.10.00.00 Shared ICU Libraries for Teradata nt-x8664 16.10
    16.10.00.00 Teradata Named Pipes Access Module 16.10
    16.10.00.00 Teradata Named Pipes Access Module nt-x8664 16.10
    16.10.00.00 Teradata OLE DB Access Module 16.10
    16.10.00.00 Teradata OLE DB Access Module nt-x8664 16.10
    16.10.00.02 Teradata BTEQ 16.10.0.2
    16.10.00.02 Teradata FastLoad 16.10.0.2
    16.10.00.02 Teradata SQL Assistant 16.10.0.2
    16.10.00.03 ODBC Driver for Teradata 16.10.0.3
    16.10.00.03 ODBC Driver for Teradata nt-x8664 16.10.0.3
    16.10.00.03 Teradata Data Connector 16.10.0.3
    16.10.00.03 Teradata Data Connector nt-x8664 16.10.0.3
    16.10.00.03 Teradata FastExport 16.10.0.3
    16.10.00.03 Teradata MultiLoad 16.10.0.3
    16.10.00.03 Teradata Parallel Transporter Base 16.10.0.3
    16.10.00.03 Teradata Parallel Transporter Base nt-x8664 16.10.0.3
    16.10.00.03 Teradata Parallel Transporter Stream 16.10.0.3
    16.10.00.03 Teradata Parallel Transporter Stream nt-x8664 16.10.0.3
    16.10.00.03 Teradata TPump 16.10.0.3
    16.10.00.05 Teradata CLIv2 16.10.0.5
    16.10.00.05 Teradata CLIv2 nt-x8664 16.10.0.5
    16.10.00.05 Teradata GSS Administration Package nt-i386 16.10.0.5
    16.10.00.05 Teradata GSS Administration Package nt-x8664 16.10.0.5
    16.10.05.00 Teradata Tools and Utilities - Base 16.10.05

    and Attunity connectors 5.0. My OS is Microsoft Windows 7 Enterprise SP1, 64 bit.
    We're running Teradata Database 15.10.

    In my existing SSIS package, my connectors using the .NET data provider for Tdata works fine.

    My MSTera connection manager returns an ODBC error:
    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
    at Microsoft.SqlServer.Dts.Runtime.ConnectionManager. AcquireConnection(Object txn)
    at Attunity.IntegrationServices.DataFlowUI.TeraDataUI .TeraConnectionDialog.testConBtn_Click(Object sender, EventArgs e)


    I can connect using SQLA via ODBC and using linked tables in MSAccess via ODBC.

    What do I need to change to get my SSIS package to work with the Attunity connector so I can use a Tdata destination data flow object?

    Thanks for your help.

    fyi, I've tried setting the project Run64BitRuntime property to both True and False, and changed the project TargetServerVersion property to SQL Server 2017.

  2. #2
    JPQuinn is offline Junior Member
    Join Date
    Feb 2017
    Posts
    9
    Rep Power
    0
    Quote Originally Posted by Beth View Post
    My PC was restaged and I've upgraded the versions of Visual Studio to 2017, SSDT to 15.1.xx, SSIS designer to 14.0.xx, TTU:
    Version Display Name
    --------------------------------------------------------------------------------------------------------------------
    14.10.00.03 Teradata Visual Explain 14.10.0.3
    15.10.01.00 Teradata GSS Client nt-x8664 15.10.1
    16.10.0.0 .NET Data Provider for Teradata 16.10
    16.10.00.00 Shared ICU Libraries for Teradata 16.10
    16.10.00.00 Shared ICU Libraries for Teradata nt-x8664 16.10
    16.10.00.00 Teradata Named Pipes Access Module 16.10
    16.10.00.00 Teradata Named Pipes Access Module nt-x8664 16.10
    16.10.00.00 Teradata OLE DB Access Module 16.10
    16.10.00.00 Teradata OLE DB Access Module nt-x8664 16.10
    16.10.00.02 Teradata BTEQ 16.10.0.2
    16.10.00.02 Teradata FastLoad 16.10.0.2
    16.10.00.02 Teradata SQL Assistant 16.10.0.2
    16.10.00.03 ODBC Driver for Teradata 16.10.0.3
    16.10.00.03 ODBC Driver for Teradata nt-x8664 16.10.0.3
    16.10.00.03 Teradata Data Connector 16.10.0.3
    16.10.00.03 Teradata Data Connector nt-x8664 16.10.0.3
    16.10.00.03 Teradata FastExport 16.10.0.3
    16.10.00.03 Teradata MultiLoad 16.10.0.3
    16.10.00.03 Teradata Parallel Transporter Base 16.10.0.3
    16.10.00.03 Teradata Parallel Transporter Base nt-x8664 16.10.0.3
    16.10.00.03 Teradata Parallel Transporter Stream 16.10.0.3
    16.10.00.03 Teradata Parallel Transporter Stream nt-x8664 16.10.0.3
    16.10.00.03 Teradata TPump 16.10.0.3
    16.10.00.05 Teradata CLIv2 16.10.0.5
    16.10.00.05 Teradata CLIv2 nt-x8664 16.10.0.5
    16.10.00.05 Teradata GSS Administration Package nt-i386 16.10.0.5
    16.10.00.05 Teradata GSS Administration Package nt-x8664 16.10.0.5
    16.10.05.00 Teradata Tools and Utilities - Base 16.10.05

    and Attunity connectors 5.0. My OS is Microsoft Windows 7 Enterprise SP1, 64 bit.
    We're running Teradata Database 15.10.

    In my existing SSIS package, my connectors using the .NET data provider for Tdata works fine.

    My MSTera connection manager returns an ODBC error:
    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
    at Microsoft.SqlServer.Dts.Runtime.ConnectionManager. AcquireConnection(Object txn)
    at Attunity.IntegrationServices.DataFlowUI.TeraDataUI .TeraConnectionDialog.testConBtn_Click(Object sender, EventArgs e)


    I can connect using SQLA via ODBC and using linked tables in MSAccess via ODBC.

    What do I need to change to get my SSIS package to work with the Attunity connector so I can use a Tdata destination data flow object?

    Thanks for your help.

    fyi, I've tried setting the project Run64BitRuntime property to both True and False, and changed the project TargetServerVersion property to SQL Server 2017.

    I'm unclear, did you make sure you have installed the ODBC driver for Teradata 32 and 64 bit on your PC, as well as running on the server for all the latest versions?

  3. #3
    JPQuinn is offline Junior Member
    Join Date
    Feb 2017
    Posts
    9
    Rep Power
    0
    Quote Originally Posted by Beth View Post
    My PC was restaged and I've upgraded the versions of Visual Studio to 2017, SSDT to 15.1.xx, SSIS designer to 14.0.xx, TTU:
    Version Display Name
    --------------------------------------------------------------------------------------------------------------------
    14.10.00.03 Teradata Visual Explain 14.10.0.3
    15.10.01.00 Teradata GSS Client nt-x8664 15.10.1
    16.10.0.0 .NET Data Provider for Teradata 16.10
    16.10.00.00 Shared ICU Libraries for Teradata 16.10
    16.10.00.00 Shared ICU Libraries for Teradata nt-x8664 16.10
    16.10.00.00 Teradata Named Pipes Access Module 16.10
    16.10.00.00 Teradata Named Pipes Access Module nt-x8664 16.10
    16.10.00.00 Teradata OLE DB Access Module 16.10
    16.10.00.00 Teradata OLE DB Access Module nt-x8664 16.10
    16.10.00.02 Teradata BTEQ 16.10.0.2
    16.10.00.02 Teradata FastLoad 16.10.0.2
    16.10.00.02 Teradata SQL Assistant 16.10.0.2
    16.10.00.03 ODBC Driver for Teradata 16.10.0.3
    16.10.00.03 ODBC Driver for Teradata nt-x8664 16.10.0.3
    16.10.00.03 Teradata Data Connector 16.10.0.3
    16.10.00.03 Teradata Data Connector nt-x8664 16.10.0.3
    16.10.00.03 Teradata FastExport 16.10.0.3
    16.10.00.03 Teradata MultiLoad 16.10.0.3
    16.10.00.03 Teradata Parallel Transporter Base 16.10.0.3
    16.10.00.03 Teradata Parallel Transporter Base nt-x8664 16.10.0.3
    16.10.00.03 Teradata Parallel Transporter Stream 16.10.0.3
    16.10.00.03 Teradata Parallel Transporter Stream nt-x8664 16.10.0.3
    16.10.00.03 Teradata TPump 16.10.0.3
    16.10.00.05 Teradata CLIv2 16.10.0.5
    16.10.00.05 Teradata CLIv2 nt-x8664 16.10.0.5
    16.10.00.05 Teradata GSS Administration Package nt-i386 16.10.0.5
    16.10.00.05 Teradata GSS Administration Package nt-x8664 16.10.0.5
    16.10.05.00 Teradata Tools and Utilities - Base 16.10.05

    and Attunity connectors 5.0. My OS is Microsoft Windows 7 Enterprise SP1, 64 bit.
    We're running Teradata Database 15.10.

    In my existing SSIS package, my connectors using the .NET data provider for Tdata works fine.

    My MSTera connection manager returns an ODBC error:
    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
    at Microsoft.SqlServer.Dts.Runtime.ConnectionManager. AcquireConnection(Object txn)
    at Attunity.IntegrationServices.DataFlowUI.TeraDataUI .TeraConnectionDialog.testConBtn_Click(Object sender, EventArgs e)


    I can connect using SQLA via ODBC and using linked tables in MSAccess via ODBC.

    What do I need to change to get my SSIS package to work with the Attunity connector so I can use a Tdata destination data flow object?

    Thanks for your help.

    fyi, I've tried setting the project Run64BitRuntime property to both True and False, and changed the project TargetServerVersion property to SQL Server 2017.
    BTW, I hear from others who were all Attuity 4.0, Teradata driver 15, and SQL Server 2016 with 32/64 bit ODBC as well as Attunity 4.0 32/64 on server, have issues with VS'17, may want to degrade (if things totally don't work out), I get the impression that VS'17 is not stable, and there may also be some lack of up/down incompatibilities

Tags for this Thread

Posting Permissions

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