Data processing extension: Custom dataset | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Data processing extension: Custom dataset

I have created a data processing extension to use a custom, external dataset. In my dataReader class, I use SqlConnection, SqlCommand and SqlDataAdapter to create the dataset.(that is I connect to a sql server, then retrive data from many tables then manipulate data into dataset). Then I use Report designer to test this extension. It works fine, I can see preview data
etc. However, When I deploy the report to web server, I encounter the following error:
—
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set ‘DataSet1’. (rsErrorExecutingCommand) Get Online Help
Request for the permission of type System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
—- I tried to sign the assembly with strong name, put assembly into global assembly cache, and set up a full trust within internet zone. All these did not work… Thank you for your help
Ensure the underlying application/user has necessary privilge to access the SQL database. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
How to ensure application/user privilege to access sql server? Thanks a lot
Check the permission for that user in database by running SP_HELPLOGINS or SP_HELPROTECT which will give you the information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
At last we solve the problem by enclosing <codegroup> tag in config file. Thanks everyone
quote:Originally posted by ssp320 At last we solve the problem by enclosing <codegroup> tag in config file. Thanks everyone
I wondered what you entered in your rspreviewpolicy.config and rspolicy.config files were. I have a DPE with the same problem when access a SQL server that is not on the same machine. trying to run the following code inside the application SqlClientPermission permission = new SqlClientPermission(PermissionState.Unrestricted);
permission.Assert(); // Assert security permission! just throws another execption Request for the permission of type System.Security.Permissions.SecurityPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
use code group like before, give full trust
Thanks
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="Dundas_Strong_Name"
Description="This code group grants Dundas assemblies. ">
<IMembershipCondition
class="StrongNameMembershipCondition"
version="1"
PublicKeyBlob="002400000480000094000000060200000024000052534131000400000100010043D98F8A9067EF3BCD442ADE2DD48CC6A6FACBCEB1C42DE2847B0A464096C02EEBF6FD87E3889BEED32B9ABD1525A11A282232CD4C46CC8123F8CC08A113CD435429646220969FF4447348D1C21874670834C7A7E89EA8956FC00E0F84FD3DF6FB3EBF21774438AF9E760414FDE06BC2C3AF35FF3DD87578630ED13FE12CBDBC"
/>
</CodeGroup>
Can somebody tell me how to get the long string for "PublicKeyBlob"? My report (uses data precess extension) worked in designer and failed on server (a seperate box). Here is the error message. Similar to the one in this thread:
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set ‘DataSet1’. (rsErrorExecutingCommand) Get Online Help
Exception has been thrown by the target of an invocation.
Request failed. Here is my CodeGroup:
<CodeGroup class="UnionCodeGroup"
version="1" PermissionSetName="FullTrust"
Name="AHC Data Access BO"
Description="AHC data access business object data processing extension">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="C:program FilesMicrosoft SQL ServerMSSQLReporting ServicesReportServerinCodeArchitects.BusinessObjectDataSource.dll" />
</CodeGroup> I’d like to try "StrongNameMembershipCondition" for "IMembershipCondition". However, I don’t know how to get that long long string for "PublicKeyBlob". Thanks for help.
Folks,
Did you get this sorted out?
Im still getting the ‘Query execution failed for data set ‘DataSet1” error and I have done everything by the book
Thanks
Mick

hi…
Your link worked good..
Can you explain about TWAIN and OCR.
THANKS IN ADVANCE.
………………
data entry india
Welcome to the forums.
What is the service pack level on SQL Server?
Are you trying to execute the queries from other tool such as CRM tools?
]]>