Load Report Failed error at setdatabaselogon

Question

I have a report run from visual studio 2008.  I logon to the database using the setdatabaselogon command but on one machine it is very temperamental it only works sometimes.  The rest of the time it errors out at the setdatabaselogon command with Load Report Failed.  Does anyone have any idea what could cause this?

Answer 1

Hi. I haven't met this problem before. But it seems it doesn't always happen. Is it temporal? Maybe there is something to do with the network connection situation?

---

Computing Network Technique information

Answer 2

Hi,

Can you post the code, to understand exactly what's the problem.

 

 

---

Regards Ayman Zaza

Answer 3

Hi. I haven't met this problem before. But it seems it doesn't always happen. Is it temporal? Maybe there is something to do with the network connection situation?

---

Computing Network Technique information

It is the way! But I still wonder why, Any related guide to learn? Could you explain it more clearly?

It's important you guys post the code to try to help you.

by the way, is your database server in another machine? O your database is locally?

 

regards

---

_________________ waraltca.

Answer 4

Hi use this code bind data to report

using CrystalDecisions.Web; 
using CrystalDecisions.CrystalReports.Engine; 
using CrystalDecisions.Shared; 

SqlConnection con = new SqlConnection(); 
  
       con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; 
  
  
       SqlCommand cmd = new SqlCommand(); 
  
       con.Open(); 
  
       cmd.Connection = con; 
  
       cmd.CommandType = CommandType.StoredProcedure; 
 
       cmd.CommandText = "sp_name"; 
 
       SqlDataAdapter da = new SqlDataAdapter(cmd); 
  
       DataSet ds = new DataSet(); 
  
      da.Fill(ds, "HarvestInfo"); 
  

       ReportDocument _rptDocument = new ReportDocument(); 
      _rptDocument.Load(Server.MapPath("ReportName.rpt")); 
_rptDocument.SetDataSource(ds.Tables["HarvestInfo"]); 
 
  
  
       ReportViewer1.ReportSource = _rptDocument; 
  
       ReportViewer1.DataBind(); 
  
       this. ReportViewer1.Visible = true;  
  
       cmd.Dispose(); 
  
       con.Close(); 
 
       ds.Dispose(); 

---

Regards Ayman Zaza

Answer 5

Code you gave worked for me. Thank you very much.

---

Kudret Çayıroğlu

Answer 6

Yes, I worked me.. Thanks

----------------------------------------------------------------

Reklam Ajansı  |  Katalog Tasarımı

Answer 7

I feel your report is not able to connect to the database in a timely manner, use veryfy command to check the connection at runtime. also try to increase the time out period

---

Please mark the replies as answers if they help. Kumar

Answer 8

Waralta, Donahue Larsen is just a seo spammer who pretend to reply in order to hide spam in quotes. Please edit your post to remove the hidden SEO link in the word "guide" inside "any related guide to learn".

---

---

The following is signature, not part of post
Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
Visual C++ MVP