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.