Database Logon Error in crystal report
- by yasar arafat
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