.NET Webservices or SSIS to DB2 RRS feed

  • Question

  • Hi,

    Would like to check few things about the DB2.

    My client has hosted the DB2 in IBM AIX UNIX.

    I need to pull some data via .Net 2.0 WebServices (Windows 2003 Server) or SQL Server 2005 (Windows 2003 Server) - SSIS from the IBM AIX UNIX DB2 Database

    In this case is it suffcient to install only .Net 2.0 DB2 Driver on the Windows 2003 Server ?

    Do I need to install some components in the IBM AIX UNIX DB2 Database also to configure the connectivity between .NET or SQL Server 2005 SSIS and DB2 ?

    The .Net 2.0 DB2 Driver is it DB2 Version Sepecific ?

    It will be really great if anyone can advise on the above.

    Get for Action
    Thursday, October 22, 2009 3:35 AM


  • I do not know the actual implementation of the driver, but I never seen any drivers/ providers that would require anything additional installed on server side. I am pretty sure installing driver on .NET client will be enough.
    Val Mazur (MVP) http://www.xporttools.net
    • Marked as answer by Yichun_Feng Wednesday, October 28, 2009 2:31 AM
    Thursday, October 22, 2009 10:04 AM