Unanswered: SQL Server Reporting Services Report Manager not able to connect to IBM DB2 databse.
I have developed a report in SQL Server 2005 Reporting Services with IBM DB2 as the database. I am using OLE DB provider for DB2 to connect to the database from SSRS. It works fine in the Business Intelligence Studio. But when I deploy it in Report Server which is configured in native mode it is not working. It is showing error like: Provider keyword is not supported. I believe that the connection string is not being recognized. The connection string I have given is: