Hi There Thanks for your posting. Please have a look on this link that might help you http://www.connectionstrings.com/ibm-db2 Many thanks Syed Qazafi Anjum

It's DB2/400 and version is DSN09015. Hope it helps. I'm new to IBM DB2 database so did not realize that there are more than one flavor of DB2. Thanks.

Hello kannadelavu I'm trying to establish connection for data source in SSRS 2008 to DB2 database. Can you provide details that what did you choose when you created DB2 connection within SSRS 2008? Which driver is best and stable for DB2 connection from SSRS? OLEDB or ODBC or .NET driver for DB2 ? Please see attached image... Jshop

Hi, What kind of DB2 are we talking about? DB2/400 or UDB? (both are completely different beasts)Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu

Hi Jshop, To use DB2 database in Reporting Services, we can install the Microsoft OLE DB driver for DB2 which is one of the Feature Pack downloads. For more information, please refer to Bin Long's answer in the following thread which has a similar topic: http://social.msdn.microsoft.com/Forums/br/sqlreportingservices/thread/294a4197-c8ef-4241-ac35-54be844b2151 Hope this helps. Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Mike Yin TechNet Community Support