Creating Datasource for DB2 database

• Shree-903371

  SSCommitted

  Points: 1930

  More actions

  February 19, 2013 at 1:12 pm

  #289797

  Hello,

  We want to create new data source connecting to DB2 database. My boss installed OLEDB drivers for IBM DB2 onto the SSRS server.

  But I'm not sure on how to create a datasource i.e. connection string? Also whether to use OLEDB or ODBC connection?

  Did somebosy has the same issue?

  Thanks in adavance.

• e4d4

  SSCertifiable

  Points: 5777

  More actions

  February 19, 2013 at 2:07 pm

  #1589369

  eg.: http://www.mssqltips.com/sqlservertip/2151/how-to-create-a-sql-server-link-server-to-ibm-db2/

• Shree-903371

  SSCommitted

  Points: 1930

  More actions

  February 19, 2013 at 2:47 pm

  #1589383

  In the above link, it showed how to create a linked server. But i need to create a datasource on SSRS server to which my reports needed to be pointed?

• Shree-903371

  SSCommitted

  Points: 1930

  More actions

  February 20, 2013 at 9:07 am

  #1589602

  I used below conncetion string and it worked.

  Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=0.0.1.23;

  Initial Catalog= Adbcfg;Package Collection=Default Schema;Default Schema= adc;User ID=user;

  Password=pass;