Post reply

Import Data From DB2 (DB2 7.02 UDB) to SQL SERVER

  • February 2, 2005 at 11:30 pm

    #88012

    Hi

    How can Import the Data from DB2 (DB2 7.02 UDB) to SQL SERVER  2000

    Any Oledb Driver or Odbc Driver from Microsoft or Any Other Sites

     

    Thanks in Advance

     

    Best Regards

    Vijay

  • February 3, 2005 at 6:10 am

    #540338

    You will need to get the DB2 client install from IBM but I believe it should be on the DB2 media itself.

  • February 3, 2005 at 6:34 am

    #540351

    I import data from AS400 using Client Access (application from IBM). It is installed on the windows server where sql sercvices run. If SQL Server users need to create connections to DB2 they also need local installation of Client Access.  

  • February 3, 2005 at 3:37 pm

    #540544

    I setup linked servers to our production as400/db400 databases.  I use the i-series access odbc driver with a odbc linked server.  I four part name my way to all of the data.  Not always the fastest but it is good enough for us.

    Tom

  • February 3, 2005 at 5:51 pm

    #540564

    Hi ,Antares686,Krystian Jedrzejczak,Tom Goltl,

    Thanks for your  Help

    Best Regards & Thanks

    Vijay Vijayaratnam

     

  • February 5, 2005 at 12:02 pm

    #540816

    Could somebody please let me know where can I get this driver?

    Krystian Jedrzejczak, could you please send me the screen shot on how the screen looks like (sqlemail@yahoo.com)

    Thanks in advance


    paul

  • August 24, 2005 at 8:01 am

    #584591

    The drivers come with IBM's Client Access software.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply