locked
Crystal Report >> Failed to load database information. Error in file temp_ {GUID_Value} .rpt RRS feed

  • Question

  • Dear Senior Programmer,

    Please help me,

    I am Agus from indonesia, could you help me regarding to "Failed to load database information. Error in file temp_ {GUID_Value} .rpt" ?

     i want to develop a simple application (client server) that can view a report based on user's Input dynamically.

    this link (http://vb.net-informations.com/crystal-report/dynamic_crystal_report_from_sql_query_string.htm) guide me to create the dynamic query code.

     

    in my development machine (local PC) the app runs well, but when i try to runs it on client machine that access to the server the app failed to run and the error message is "Failed to load database information. Error in file temp_ {GUID_Value} .rpt"

    i've tried to read all solution in every forum, but i still can't find what is the mistake.

    Here is the software installed on my development machine (local) :

    ~ Windows XP Professional SP3 (32-bit)

    ~ Microsoft SQL Server 2000 SP4

    ~ VS. Net Ultimate 2010

    ~ Dot Net Framework 4

    ~ Crystal Report for VS 2010 SP3 (32-bit)

    ~ CRforVS_redist_install_32bit_13_0_3 (CR runtime engine 32-bit)

     

    Here is the software installed on my client machine :

    ~ Windows XP Professional SP3 (32-bit)

    ~ Microsoft SQL Server 2000 SP4

    ~ CRforVS_redist_install_32bit_13_0_3 (CR runtime engine 32-bit)

    ~ the source code folder

    this is my snippet code:

    Imports CrystalDecisions.CrystalReports.Engine
    Imports CrystalDecisions.Shared
    Imports System.Data.SqlClient
    Imports System.Data

    Dim cryRpt As New cR_ExpDoc

    Private Sub FrmPrintExpDoc_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
            Dim ds As New DataSet1
            ds.Clear()

            Dim xserver As String

            Dim objReader As New System.IO.StreamReader(FILE_NAME)
            xserver = objReader.ReadToEnd
            objReader.Close()

            Dim kon As SqlConnection = New SqlConnection("server='" & xserver & "';uid=sa;pwd=it;database=dbLegalDoc;connect timeout=0")
            kon.Open()

            Dim sql As String

            cryRpt.Load("\\" & xserver & "\WindowsApplication1\ReminderProj\cR_ExpDoc.rpt")

            sql = procesSQL()

            Dim dscmd As SqlDataAdapter = New SqlDataAdapter(sql, kon)

            dscmd.Fill(ds, "DataTable1")

            kon.Close()

            'cryRpt.SetDataSource(ds.Tables(0))
            cryRpt.Database.Tables(0).SetDataSource(ds)
            CrystalReportViewer1.ReportSource = cryRpt
            CrystalReportViewer1.Refresh()

    End Sub

    Any Help would be very appreciated, thank you so much.

    regards,

    AGUS SALIM - Indonesia (agus.salim@asia.com)

    • Moved by Jie Bao Thursday, July 5, 2012 2:47 AM (From:Visual Basic General)
    Friday, June 29, 2012 8:32 AM

All replies