am really very dumb as this problem is being answered so many times but eally its above my head.

i dont have any idea about working with crystal reports or asp.net but due to some reason i have to work on it.

after trying very hard i m able to design on crystal report connecting it with mysql database.

now when i see in the crystalreport preview i am able to see the report and the data ![enter image description here][1]

but when i try to run it on server it says database logon failed![enter image description here][2]

now i really dont know what to do

i am pasting my aspx and aspx.vb code here

and please repley in english not computer language believe me i m super dumb

enter code here

aspx codes

<%@ Page Title="" Language="VB" MasterPageFile="~/Master/Site.master"AutoEventWireup="false" CodeFile="ManHourCostExpenditure.aspx.vb" Inherits="ManHourCostExpenditure" %>
<%@ Register assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" namespace="CrystalDecisions.Web" tagprefix="CR" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
    <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" 
        AutoDataBind="True" EnableDatabaseLogonPrompt="False" 
        EnableParameterPrompt="False" 
        GroupTreeImagesFolderUrl="" Height="1202px" 
        ReportSourceID="CrystalReportSource1" ToolbarImagesFolderUrl="" 
        ToolPanelView="None" ToolPanelWidth="200px" 
        Width="903px" BorderColor="#660033" BorderStyle="Solid" 
        BorderWidth="1px" HasCrystalLogo="False" />
    <CR:CrystalReportSource ID="CrystalReportSource1" runat="server">
        <Report FileName="CrDiscProjManHoursActVsEst.rpt">
        </Report>
    </CR:CrystalReportSource>
</asp:Content>

aspxdotvb codes

Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Imports CrystalDecisions.Enterprise
Imports CrystalDecisions.ReportSource
Imports CrystalDecisions.Web
Imports CrystalDecisions.Windows.Forms
Imports MySql
Imports MySql.Data
Imports MySql.Data.MySqlClient

Imports System.Collections
Imports System.Collections.Generic
Imports System.Text
Imports CrystalDecisions
Imports CrystalDecisions.CrystalReports
Imports CrystalReportsReportDefModelLib
Partial Class ManHourCostExpenditure
    Inherits System.Web.UI.Page
    Dim CrRpt As New CrystalDecisions.CrystalReports.Engine.ReportDocument
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

        Dim StrConn As String = "SERVER=localhost;DATABASE=fluor;UID=root; PWD=root;"
        Dim Conn As New MySqlConnection(StrConn)
        Conn.Open()
        Dim CrRpt As New CrystalDecisions.CrystalReports.Engine.ReportDocument
        'Session.Add("REPORT_KEY", CrRpt)
        CrRpt.Load(Server.MapPath("CrManHourCostExpenditure.rpt"))
        CrRpt.PrintOptions.PaperOrientation = PaperOrientation.Landscape
        'If IsPostBack Then
        '    CrRpt = CType(Session.Item("REPORT_KEY"), Group)
        '    CrystalReportViewer1.ReportSource = CrRpt
        'End If
        CrystalReportViewer1.ReportSource = CrRpt
        'CrystalReportViewer1.DataBind()
        CrystalReportViewer1.RefreshReport()
        Conn.Close()
        'CrRpt.Close()
        'CrRpt.Dispose()


    End Sub




 Protected Sub Page_Unload(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Unload
        'CrystalReportViewer1.ReportSource.Close()
        CrRpt.Close()
        CrRpt.Dispose()
    End Sub

    'Protected Sub CrystalReportViewer1_Unload(ByVal sender As Object, ByVal e As System.EventArgs) Handles CrystalReportViewer1.Unload
    '    CrRpt.Close()
    '    CrRpt.Dispose()
    'End Sub


End Class

please help me.

thanks in advance.... yasir