anis ahmed

anis ahmed

  • NA
  • 16
  • 0

How to run a rdlc report in web server using reportviewer and MySQL ODBC provider?

Dec 1 2010 9:35 AM
Hi all,
I have developed a asp.net 2.0 application using MySQL. In that application i have to run reports in web server. I have used rdlc report through microsoftReportViewer. Database is MySQL connected using OBDC 3.51 Provider. My application and reports are ok in local mode. But when i upload it to web server the following error message is displaying..........

  • The request failed with HTTP status 401: Unauthorized
My code that is..........

protected void Page_Load(object sender, EventArgs e)
    {
       
        ReportViewer1.ProcessingMode = ProcessingMode.Remote;       
        ReportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://75.127.108.138/reportserver");
        ReportViewer1.ServerReport.ReportPath = "Reports/rptStudent.rdlc";
        ReportViewer1.ServerReport.Refresh();
    }

Please give me a solution. Its very much needed to me. Thanks in advance.

Answers (1)