Symptom
- Connecting to an Oracle database results in the error message;
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.
- Same code works for MS SQL database
- Code also works as expected on the development system
Environment
- Visual Studio 2005
- Crystal Reports XI release 2 (SP6)
- MS Server 2003 R2 standard edition Service Pack 2
Cause
The worker process for ASP.NET the handles Crystal Reports did not have permissions to read the Oracle directory and the TNSNAMES file saved within this directory.
Resolution
- Allow at least read permissions to the worker process so that the Crystal Reports engine can get the routing information from the TNSNAMES files
- For similar permission issues, use the Process Monitor utility.
Keywords
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