2 สิงหาคม 2555 20:19
Hi, I have access to list of our saved data source files .rsds. I am have a custom assembly methods using c# and like to create a method that uses my existing data source files to access our databases.
My custome assembly .dll file is working very well just want to add another functionality into it. Is it possible and if so any examples or info that I can start with would be perfect.
6 สิงหาคม 2555 20:21
I have found this link but not that clear to me
6 สิงหาคม 2555 20:56
The link that rv7a99cv gave you is exactly what you are looking for. The only thing is that the documentation is sometimes shady for that object. You must use the function GetDataSourceContents(strDataSourceName). It will give you a DataSourceDefinition object.
Inside the said DataSourceDefinition , there is a member ConnectString, CredentialRetrieval and everything you need to connect to your database.
Hope this helps,
AlexEdit : This implies that your rds are deployed on your server.
6 สิงหาคม 2555 23:31
Thank you Alex, as I was searching and looking around found another link http://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010.getdatasourcecontents I think I have to use this one as I have our reporting servicies is on sharepoint.
I know some how I have to access the http://<Server Name> /_vti_bin/ReportServer/ReportService2010.asmx";
Which in SQL Server 2008R2 the reportService2005.asmx not 2010. I don't understand the top part (code) of the above url.
7 สิงหาคม 2555 16:08
The URL is simply
The name of <NameOfWebserviceUrlVirtualDirectory> can be found in the Reporting Service Configuration Manager in the Web Service URL Tab.
Edit : I have no clue what the /_vti_bin is and I don't think it is really necessary. Well I never added that in my url and it worked. It might be their Virtual Directory that is set to /_vti_bin/ReportServer
8 สิงหาคม 2555 11:24ผู้ดูแล
Thanks for your posting.
If you are using SQL Server 2008 R2 Reporting Services, you can use the ReportingService2006.SetDataSourceContents Method or the ReportingService2010.SetDataSourceContents Method. As for the /_vti_bin/ in the URL of the sample, I agree with Alex that it should be the virtual directory.
TechNet Community Support
9 สิงหาคม 2555 0:25
thank you both, I will try and keep you posted. Thanks again for your replies.