Reporting Services using IBM DB2 Data Provider for .NET framework 2.0

Hello, I have been testing the IBM DB2 .NET data provider the last couple of months with the intention too use it with Reporting Services. I am using the IBM DB2 Data Provider for .NET framework 2.0. Everything seems too work fine until I started too test the Cashing and Scheduling of reports in Reporting Services.
Too be able too cash or too schedule reports in Reporting Services you have too set the "Credientials stored securely in the report server". The problem is when I do this with the Data Connection using the IBM .Net Provider I get an error Message:

"The data source 'XXXX' uses a managed data provider which does not implement IDbConnectionExtension. Only Windows Integrated Security or No Credentials are supported."

Is it possible too write a wrapper around the IBM dataprovider too implement IdbConnectionExtension and thereby extend the SSRS security model or is this something IBM have too do in the provider.

You can implement the wrapper yourself. Use this documentation to get started: http://msdn2.microsoft.com/en-us/library/ms154655(SQL.90).aspx

-- Robert

|||

Ok, thanks. I will look into this in a couple of days. Will this kind of wrapper couse much overhead or lack of performance?

I still wonder why IBM has not implemented this Interface in their release of the dataprovider.

B

|||

The purpose of the wrapper is mainly to "link" the defined interfaces, properties and methods to the underlying managed DB2 provider.

Your data extension wrapper should not perform any real data processing - just passing through calls. Hence, there won't be any significant overhead.

-- Robert

|||Were you able to create this provider?