Configuration:
Asp.Net 2.0
Oracle 10g.
Visual Studio 2005 Prof. Ed.
Crystal Reports 10 Adv. Dev.
A simple crystal report named "Report1.rpt" is built in crystal reports 10 Adv. Dev. and works fine when run in CR Designer mode.
However, accessing it from Asp.Net page gives following error:
“Failed to load database information. Details: The database DLL 'crdb_oracle.dll' could not be loaded. Error in File C:\WINDOWS\TEMP\Report1
{F5957DEE-E12A-4456-B718-50C6EE90BA46}.rpt: Failed to load database information.”
Stored procedure is as follows:- PROCEDURE proc_list_group ( rcv_allgroups OUT SYS_REFCURSOR) IS BEGIN -- executable part starts here OPEN rcv_allgroups FOR SELECT * FROM tblgroup;
END "PROC_LIST_GROUP";
Asp.Net page is as follows:-<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <CR:CrystalReportSource ID="CrystalReportSource1" runat="server"> <Report FileName="C:\LMEdo_Reports\Report1.rpt"> </Report> </CR:CrystalReportSource> <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="true" ReportSourceID="CrystalReportSource1" EnableParameterPrompt="False" EnableDatabaseLogonPrompt="False" /></asp:Content> Asp.Net page behind file is as follows:- Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim rep As CrystalDecisions.CrystalReports.Engine.ReportDocument = CrystalReportSource1.ReportDocument Dim db As CrystalDecisions.CrystalReports.Engine.Database = rep.Database Dim tblst As CrystalDecisions.CrystalReports.Engine.Tables = db.Tables Dim tbl1 As CrystalDecisions.CrystalReports.Engine.Table = tblst.Item(0) Dim loginfo As CrystalDecisions.Shared.TableLogOnInfo = tbl1.LogOnInfo loginfo.ConnectionInfo.UserID = "usercommon" loginfo.ConnectionInfo.Password = "usercommon" loginfo.ConnectionInfo.ServerName = "LMEDo" loginfo.ConnectionInfo.Type = CrystalDecisions.Shared.ConnectionInfoType.Unknown tbl1.ApplyLogOnInfo(loginfo) Me.DataBind()
End Sub
Solutions tried:-
Tried installing, Oracle client 10.2, but in vain. Path variable is set properly Oracle_Home as suggested by business objects in one of their post.
Observation:-
Creating a new connection in visual studio 2005 doesn’t show any option as “Oracle Server”, as it appears in Crystal Reports 10 Adv. Dev.