InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 13:05:48 GMT20http://www.sqlservercentral.com/Forums/Topic1421823-1632-1.aspxI 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;Wed, 20 Feb 2013 09:07:40 GMTShree-903371http://www.sqlservercentral.com/Forums/Topic1421823-1632-1.aspxIn 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?Tue, 19 Feb 2013 14:47:20 GMTShree-903371http://www.sqlservercentral.com/Forums/Topic1421823-1632-1.aspxeg.: [url]http://www.mssqltips.com/sqlservertip/2151/how-to-create-a-sql-server-link-server-to-ibm-db2/[/url]Tue, 19 Feb 2013 14:07:51 GMTe4d4http://www.sqlservercentral.com/Forums/Topic1421823-1632-1.aspxHello, 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.Tue, 19 Feb 2013 13:12:29 GMTShree-903371