Solved

Crystal Reports Server Failed to load database information

Posted on 2009-07-09
5
2,549 Views
Last Modified: 2012-05-07
I have a Crystal Report that works just fine as designed in Crystal XI connecting to my Oracle database.  I have installed and configured Crystal Reports Server and uploaded the report to the CMC into a new folder.  When I try to run or preview the report, I get the message "Failed to Load Database Information".  In the process/database settings I have tried both using the original database login information from the report, supplying the correct username and password and I have also tried using the custom settings for Oracle.  Both return the same error.  I have Oracle 9i client installed on my Crystal Server (Windows Server 2003) and can connect without a problem to my Oracle database using SqlPlus.  Please help me in finding why my report will not run via Crystal Server.  I am trying to get it to run so that I can schedule this report to run on a daily basis.  I have read other questions and answers on Experts Exchange but they either do not pertain to my issue or I tried the resolution provided but it did not help.  Thanks in advance.
0
Comment
Question by:LRI1
  • 3
5 Comments
 
LVL 14

Assisted Solution

by:LinInDenver
LinInDenver earned 50 total points
ID: 24824585
The only thing I can think of - is the ODBC connection created on the CE Server, and named the same as the machine the report was built on? You mentioned you have the ability to connect on it through SQL Plus, but I can't remember if that means your ODBC is set (I've been away from Oracle for 1.5 years now).

Even though your ODBC connections will display in the CMC on the Database properties (which in the past made me think I didn't have to do anything!) you still need to create an ODBC on the actual CE server.

Hope this helps some how - good luck!
Lin
0
 

Author Comment

by:LRI1
ID: 24824711
Hi,

I am not connecting with ODBC on the report so I should not need it on the CE server.  I connect via the Oracle Server connection packaged with Crystal Reports.  However, yesterday I did set up an ODBC connection from my CE server and chose that in the process/database properties of the report.  Same error.  Thanks for trying.  Anyone else have any insight?
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 50 total points
ID: 24832371
Did you install the Oracle database driver from Crystal on the server?

mlmcc
0
 

Author Comment

by:LRI1
ID: 24843791
Not quite sure what you mean.  The Oracle driver was installed when I installed Crystal Reports Server.  It shows that I have the Oracle driver as an option under custom database login information.
0
 

Accepted Solution

by:
LRI1 earned 0 total points
ID: 24850961
I was able to get it to work!  For anyone else who has this issue, try the following.

From the Crystal Server. Go to Start-->Programs--> Business Objects-->Crystal Report Server-->Central Configuration Manager.

Now for Crystal Reports Job Server and Crystal Reports Page Server right click and select properties. Both the accounts should be running under an admin account and not LocalAdmin. I changed them to run under my domain admin account since my domain admin has full access to my Oracle Database server.

That worked for me!
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now