Accepted Solutions (1)
Hi Ludek,
Well, if you mean by 32 bit that "Enable 32-Bit Applications" is True, then yes it is:
I discovered today that the service and report WORKS with the Oracle 11.2.0.1 32-bit client (Admin install type) and the Crystal Reports runtime engine for .NET Framework 4 (32-bit) . It does NOT work with the Oracle 10.2.0.3 32-bit client.
However, on another Win 2008 R2 server with the Oracle 10.2.0.3 32 bit client and Crystal Reports 2011 (desktop/designer product), I can use Crystal desktop to preview and render the report file, I can connect, specify parameters, refresh with data and export it as a PDF.
Do you know if there is a way to submit a bug report for Crystal Reports runtime engine for .NET Framework 4 (32-bit)? Is there a way to tell if Othe racle 10.2.0.3, 32-bit, is a supported client for the runtime components?
Thanks,
Carl Trapani
Dear Mr. Ludek Uher,
I am Agus from indonesia, could you help me regarding to "Failed to load database information" ?
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 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 [filename] {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 folder source code
This is my snippet code:
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Imports System.Data.SqlClient
Imports System.Data
Public Class FrmPrintExpDoc
Dim cryRpt As New ReportDocument
Public Function procesSQL() As String
Dim sql As String
Dim inSql As String
Dim firstPart As String
Dim lastPart As String
Dim selectStart As Integer
Dim fromStart As Integer
Dim fields As String()
Dim i As Integer
Dim MyText As TextObject
inSql = "SELECT " & SelectedCol & " FROM T_TKASPONS WHERE " & ValueCboxSpons & " CONVERT(datetime, " & ValueCboxDoc & " , 106) between " & "'" & valDTPExp & "'" & " and " & "'" & valDTPExpUntil & "'" & " Group By " & SelectedCol & " Order By Nama_Sponsor"
inSql = inSql.ToUpper
selectStart = inSql.IndexOf("SELECT")
fromStart = inSql.IndexOf("FROM")
selectStart = selectStart + 6
firstPart = inSql.Substring(selectStart, (fromStart - selectStart))
lastPart = inSql.Substring(fromStart, inSql.Length - fromStart)
fields = firstPart.Split(",")
firstPart = ""
For i = 0 To fields.Length - 1
If i > 0 Then
firstPart = firstPart & " , " & fields(i).ToString() & " AS COLUMN" & i + 1
MyText = CType(cryRpt.ReportDefinition.ReportObjects("Text" & i + 1), TextObject)
MyText.Text = fields(i).ToString()
Else
firstPart = firstPart & fields(i).ToString() & " AS COLUMN" & i + 1
MyText = CType(cryRpt.ReportDefinition.ReportObjects("Text" & i + 1), TextObject)
MyText.Text = fields(i).ToString()
End If
Next
sql = "SELECT " & firstPart & " " & lastPart
Return sql
End Function
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") 'ACCESS TO THE SERVER THROUGH LOCAL AREA NETWORK (LAN)
sql = procesSQL()
Dim dscmd As SqlDataAdapter = New SqlDataAdapter(sql, kon)
dscmd.Fill(ds, "DataTable1")
kon.Close()
cryRpt.SetDataSource(ds)
CrystalReportViewer1.ReportSource = cryRpt
CrystalReportViewer1.Refresh()
End Sub
End Class
Thank you for your help Mr. Ludek, I would be very appreaciate your kindness. God Bless You...
regards,
Agus Salim - Indonesia
Answers (0)
| User | Count |
|---|---|
| 83 | |
| 10 | |
| 10 | |
| 9 | |
| 7 | |
| 6 | |
| 5 | |
| 5 | |
| 4 | |
| 3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.