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

[EDN Admin]

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 users Input dynamically.
this link ( http://vb.net-informations.com/crystal-report/dynamic_crystal_report_from_sql_query_string.htm http://vb.net-informations.com/crystal-report/dynamic_crystal_report_from_sql_query_string.htm ) guide me to create the dynamic query code.
<p style="min-height:8pt; height:8pt; padding:0px
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"
ive tried to read all solution in every forum, but i still cant 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)
<p style="min-height:8pt; height:8pt; padding:0px
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<br/>
Imports CrystalDecisions.Shared<br/>
Imports System.Data.SqlClient<br/>
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<br/>
Dim ds As New DataSet1<br/>
ds.Clear()<br/>
<br/>
Dim xserver As String<br/>
<br/>
Dim objReader As New System.IO.StreamReader(FILE_NAME)<br/>
xserver = objReader.ReadToEnd<br/>
objReader.Close()<br/>
<br/>
Dim kon As SqlConnection = New SqlConnection("server=" & xserver & ";uid=sa;pwd=it;database=dbLegalDoc;connect timeout=0")<br/>
kon.Open()<br/>
<br/>
Dim sql As String<br/>
<br/>
cryRpt.Load("\" & xserver & "WindowsApplication1ReminderProjcR_ExpDoc.rpt")<br/>
<br/>
sql = procesSQL()<br/>
<br/>
Dim dscmd As SqlDataAdapter = New SqlDataAdapter(sql, kon)<br/>
<br/>
dscmd.Fill(ds, "DataTable1")<br/>
<br/>
kon.Close()<br/>
<br/>
cryRpt.SetDataSource(ds.Tables(0))<br/>
cryRpt.Database.Tables(0).SetDataSource(ds)<br/>
CrystalReportViewer1.ReportSource = cryRpt<br/>
CrystalReportViewer1.Refresh()<br/>
<br/>
End Sub

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

regards,

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



View the full article