We have a web app that launches Crystal Reports (version 8) in the crystal reports viewer that plugs into IE (version 6.0 & 7.0). The reports connect to SQL Server 2005. We have some reports that work but we have 2 reports that used to work but stopped working since we made the change. Whenever we launch the report from the browser we get
u2018Error detected by database DLL. [On Page Server: server_name]u2019
This is very frustrating as we have
1.
Recreated the reports from scratch
2.
Checked the connection to the database
3.
We connect to the live server using Terminal Server and we installed Crystal on the terminal server and the reports run fine there.
4.
We had the report s working after the modification but for some strange reason they stop working and we start getting the above error
5.
Also we have noticed that sometimes when we remove the query string (?sf=...) to the report it works (actually we get the login screen - but it works fine after that).
6.
Please note that the reports with the query string work fine on our test server and on my local machine connecting to a local copy of the database.
I am now very confused and would be very grateful for any help on this issue.
Best regards
Jose