Forum Discussion

tschary's avatar
tschary
Copper Contributor
May 30, 2024

Microsoft OLE DB Provider for DB2 version 4.0

Hi All,   I am looking for Microsoft OLE DB Provider for DB2 Version 4.0 update  9.0.1428.0 . I think this is a part of  SQL Server 2012 Service pack 1 feature . I tried to get these software's but...
  • tschary's avatar
    tschary
    Copper Contributor
    Jun 02, 2024

    Hi olafhelper , we have SQL Server 2012 SSIS packages supports only updated Microsoft DB2 4.0 OLE db provider. I have tried in Visual studio for DB2 other versions 5.0,6.0 &7.0 but no luck. Pease help me to get the same version.

    • olafhelper's avatar
      olafhelper
      Bronze Contributor
      Jun 03, 2024
      "But no luck" means what in detail? With that less on information no one can guess.
      I never noticed that SSIS cares about any OleBD driver version.
      • tschary's avatar
        tschary
        Copper Contributor
        Jun 03, 2024
        Hi olafhelper ,

        Recently we did a physical db server migration with the same setup. we built a new db server and then old db server decommissioned.
        The setup is like below.
        OS Server: windows server 2019
        source DB server: SQL Server 2017
        Destination : AS400 db2 databse V7R3

        SSIS jobs which are SQL SERVER 2012 deployed packages are running fine before migration.
        After migration same SSIS Jobs are failing because we don't have same version of DB2OLEDBV4 in new db server. And SQL SERVER 2012 deployed SSIS packages supports only DB2OLEDB V4 . And
  • tschary's avatar
    tschary
    Copper Contributor
    May 31, 2024

    Hi olafhelper , Thanks for the response. Our environment is Databases are migrated from SQL Server 2012 to SQL Server 2017 and the SSIS packages are deployed and still running with SQL Server 2012. Those packages are importing data from AS400 into SQL database. So when i try to use DB2 version 5.0 or 6.0 or 7.0 the DB2 provider is not supporting and unable to import data from AS400 (V7R3). 

     

    last two months we did data center migration , the old SQL server with same setup had worked with DB2 version 4.0. with updated number 9.01428.0.

    I have found the initial version of DB2 4.0 -  9.0.1390.0 but it is not working for few columns while importing data from AS400 into SQL server and Microsoft had released 9.0.1428.0 which will fix those columns.

     

    Please help me to get the same version.

     

    Could you please help. 

     

    Thanks,

    Sreenivasa

     

     

Resources