Solved

Crystal Reports Server Failed to load database information

Posted on 2009-07-09
5
2,563 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

816 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

12 Experts available now in Live!

Get 1:1 Help Now