This is a migrated thread and some comments may be shown as answers.

Report works locally but not on hosting server

2 Answers 274 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

Felice asked on 21 Oct 2013, 03:55 PM

Schermata-2013-10-21-alle-17-49-49.png

I am going mad with this:
I have made a report in a class library and then referenced the DLL in my website project.
Added the viewer and the code in the page behind:

protected void Page_Load(object sender, EventArgs e)

{

ReportViewer1.Report = new MyClassRep1.IndustryRep();

}

Locally on my machine is working fine. No problems of any type. Beautiful.
Then I change the string in the web.config from the local database :

<add name="stad_conn" connectionString="Data Source=WIN-72PL3253COR\SQLEXPRESS;Initial Catalog=DataIntelli1;Integrated Security=True;"/>

to the production database:

<add name="stad_conn" connectionString="Data Source=foooo.db.1and1.com;

Initial Catalog=fooo;

uid=fooo;

pwd=myPassword" providerName="System.Data.SqlClient" />

And when I finally try to run the report on the production server I get the following message (also in the attached pic):

"""An error has occurred while processing Report 'IndustryRep': Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed."""

What is very strange is that I have other additional 4 reports on the same website out of the same class library that works without problems.
What could be wrong on this particular report?
Some help will be appreciated.
Thanks,
Felice

2 Answers, 1 is accepted

Accepted