Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Production Database Problem (ASP.NET + C# + CrystalRpt + SQL Serv )

Status
Not open for further replies.

Mukhomedshin

Programmer
Feb 28, 2003
2
CA
When I move my application from development db to production db it stops working and gives message "Failed to load database information". It happens on the very last line of the code below:

crvReportViewer.ReportSource = oRpt;

If I comment this line I have no error and can see the viewer (empty of course)

Can anybody give me an idea what is wrong?

FM

//--------------------
namespace sd
{
public class MyReport : System.Web.UI.Page
{
private string strSelectionFormula="";
private string strRptName="";
protected CrystalDecisions.Web.CrystalReportViewer crvReportViewer;
private ReportDocument oRpt = new ReportDocument();
override protected void OnInit(EventArgs e)
{
InitializeComponent();
base.OnInit(e);

string strConnectionString = ConfigurationSettings.AppSettings["appsqlstr"];

objConn = new SqlConnection(strConnectionString);
dataSet = new DataSet();
objAdapter = new SqlDataAdapter( strSelectionFormula, objConn);
objAdapter.Fill(dataSet, "SERVICECALLS");

oRpt.SetDataSource(dataSet);
Response.Write(&quot;<BR>&quot;);
crvReportViewer.ReportSource = oRpt;
}
 
The solution was to install on server additional Crystal Report component, responsible for database communication - it seems it is not part of standard installation.
 
I have the same error. I have followed the instructions in cr9net_deployment.pdf. What was the additional component?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top