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

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Subhendu De15y ago
Check this one

http://subhendude.blogspot.com/2008/06/how-to-dynamically-bind-dataset-to.html

// Set the processing mode for the ReportViewer to Local
ReportViewer1.ProcessingMode = ProcessingMode.Local;

Thanks.....
0