Accessing DB2 via ODBC from SQL Server

• me_balaji

  SSC Eights!

  Points: 923

  More actions

  December 20, 2005 at 1:36 pm

  #91052

  Do you know of a way to connect to a DB2 database via ODBC by simply installing an ODBC driver?

  Which ODBC Driver is best in market ?

  Thanks

• abates100

  SSC Veteran

  Points: 202

  More actions

  December 21, 2005 at 7:48 am

  #610839

  We use the IBM DB2 UDB iSeries OLEDB provider (Client Access is the name of the product I think).  Fortunantly MS included a DB2 driver in 2005.

   

  AB

• kgottfredsen

  Mr or Mrs. 500

  Points: 542

  More actions

  December 21, 2005 at 8:02 am

  #610844

  You can download IBM's DB2 run-time client here:

   

  http://www-306.ibm.com/software/data/db2/udb/support/downloadv8.html

   

  The run-time client includes the DB2 ODBC driver.

   

  If the DB2 database is on z/OS or AS/400, you'll need to use DB2 Connect to access it.