Symptom
- Report connecting to Oracle using the below code
Dim connection As ConnectionInfo
connection = New ConnectionInfo()
With connection
.ServerName = Our Server Name Here
.UserID = Our User ID Here
.Password = Our Password Here
.DatabaseName = Our Database Name Here
.Type = ConnectionInfoType.SQL
End With
Dim CRTableLogOnInfo As TableLogOnInfo
For Each Tbl As Table In Report.Database.Tables
CRTableLogOnInfo =Tbl.LogOnInfo
CRTableLogOnInfo.ConnectionInfo = connection
Tbl.ApplyLogOnInfo(CRTableLogOnInfo)
Tbl.Location = Our Schema Here & "." & Tbl.Location
Next
- Running an application with the above code results in the error:
Failed to load database information. Error in File C:\WINDOWS\TEMP\Arrivals By Date {E4D4AF52-E6B4-4C22-89E9-2FE809C23F8E}.rpt: Failed to load database information.
Cause
The worker process for ASP.NET the handles Crystal Reports did not have permissions to read the Oracle directory and the TNSNAMES file in the directory.
Resolution
At minimum, allow read permissions to the worker process on the Oracle directory so that the worker process can read the TNSNAMES file.
Keywords
Forum thread , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , How To
Product
Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 10.0 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 9.0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2