reporting services - How to register custom data provider in C# -

we have middle tier provide data. trying write custom data provider. have overriden intefaces of system.data namespace idbcommand, idbconnection , generated dlls.

we wanted register dll.so, should listed in data source type window of ssrs.

we not able register it. can help?

development setup

on development machine, dll data extension needs installed in visual studio directory. like:

c:\program files (x86)\microsoft visual studio 8\common7\ide\privateassemblies 

in same folder need add data extension rsreportdesigner.config follows: in <extensions> <data> section, add following line:

<extension name="mydataextension" type="my.name.space.mydataextensionclass"/> 

in <extensions> <designer> section, add following line:

<extension name="mydataextension" type="microsoft.reportingservices.querydesigners.vdtquerydesigner,microsoft.reportingservices.querydesigners"/> 

you need add full trust data extension function properly. edit rspreviewpolicy.config , add following code security group:

<codegroup class="unioncodegroup"     version="1"     permissionsetname="fulltrust"     name="mydataextensioncodegroup"     description="code group data processing extension">     <imembershipcondition class="urlmembershipcondition"         version="1"         url="c:\program files (x86)\microsoft visual studio 8\common7\ide\privateassemblies\mydataextension.dll"     /> </codegroup> 

now can use data processing extension in visual studio.

server setup

on reporting services server, data extension dll needs installed in sql server reporting services directory. like:

c:\program files\microsoft sql server\mssql.1\reporting services\reportserver\bin 

in main reportserver directory above bin directory need add data extension rsreportserver.config. in <extensions> <data> section, add following line:

<extension name="mydataextension" type="my.name.space.mydataextensionclass"/> 

to give dll full trust, edit rssrvpolicy.config , add following code security group:

<codegroup class="unioncodegroup"      version="1"     permissionsetname="fulltrust"     name="mydataextensioncodegroup"     description="code group data processing extension">     <imembershipcondition class="urlmembershipcondition"         version="1"         url="c:\program files\microsoft sql server\mssql.1\reporting services\reportserver\bin\mydataextension.dll"     /> </codegroup>