Reputation: 2938
I have a web application developed on ASP.NET 4.0
, SQL SERVER 2008
and Crystal Report 2008
. When running on VS2010
it works fine but when i deploy it on IIS 7
reports are not working.
I googled it and found many solution but non of them working.
Please tell me the solution. Furthermore the reports are working on IIS6.
The error is in the below image
Upvotes: 1
Views: 2977
Reputation: 2938
Finally, I got the solution*. I was using ODBC
and it was the problem.
I deleted the connection from the User DNS and created in System DSN.
*I got that a year ago but it is for people who are searching. It might help.
Upvotes: 0
Reputation: 144
I'm running IIS7 with Crystal with no issues. Out of the blue, certain reports started failing and creating lock files in c:\windows\temp.
The only fix, so far for me, was to open each report and perform the following:
File > Page Setup > Check off the following option "No Printer (optimize for screen display)"
Afterwards I stopped the application pool, cleaned up the c:\windows\temp
directory and started the application pool again. All issues have since been resolved.
This assumes you have a working IIS7 environment to begin with
Upvotes: 3