Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Failed to load database information Post Reply Post New Topic
Author Message
jeff.litwiller
Newbie
Newbie
Avatar

Joined: 14 Feb 2011
Location: United States
Online Status: Offline
Posts: 2
Quote jeff.litwiller Replybullet Topic: Failed to load database information
    Posted: 14 Feb 2011 at 3:51am
We installed a new Crystal Report Server and transfered everything over but keep getting an error
 
example
changing parameters
An error has occurred: Error in File AP Aging by Group (over 90)(excel): Failed to load database information.
 
running report
Error in File C:\Business Objects\BusinessObjects Enterprise 11.5\Data\procSched\HKCRYSTAL1.reportjobserver\~tmpbc867c0ea92c0b2.rpt: Failed to load database information.
 
Trying to connect to an Oracle database.
Installed the full Oralce client and tested the connection.
 
Any Ideas.
 
I am working with someone from Oracle but waiting for a Senior engineer.
 
IP IP Logged
jeff.litwiller
Newbie
Newbie
Avatar

Joined: 14 Feb 2011
Location: United States
Online Status: Offline
Posts: 2
Quote jeff.litwiller Replybullet Posted: 14 Feb 2011 at 5:41am
Finally found the solution to my problem.
 
On a 64bit machine, you have to install the 32 bit oracle client. You also have to set up a 32 bit ODBC to see your 32 bit client. Use %WINDIR%\SYSWOW64\odbcad32.exe to get to the 32 bit ODBC Admin tool. I also had to reboot the server for it to function correctly.
IP IP Logged
Divi_2010
Newbie
Newbie


Joined: 16 Feb 2011
Online Status: Offline
Posts: 7
Quote Divi_2010 Replybullet Posted: 16 Feb 2011 at 12:54pm
Hi,

I migrated few crystal reports from r2 to r3.1 and I am getting the error as "Failed to open the connection". The reports are accessing the SQL Server2005 DB.
But,
1.If I open the report in the crystal designer 2008 it’s working fine and I am able to run the report.
2.Saved the report locally and re-exported the report to the repository.
3.Now if I rerun the report from the Infoview or CMC, I am able to run the report.

This looks strange. I did not change any connections or anything for that matter.

I request you to help me out in this regard.

Thanks.
IP IP Logged
rob35244
Newbie
Newbie


Joined: 02 Feb 2011
Online Status: Offline
Posts: 3
Quote rob35244 Replybullet Posted: 15 Mar 2011 at 5:03am
We are hitting the same issue with importing reports from r2 to r3.1
 
Did you get a resolution for the issue yet?
IP IP Logged
Divi_2010
Newbie
Newbie


Joined: 16 Feb 2011
Online Status: Offline
Posts: 7
Quote Divi_2010 Replybullet Posted: 15 Mar 2011 at 5:12am
Is your OS 64 bit or 32 bit? If it's a 64 bit, you need to create a 32 bit odbc drivers and make sure you have configured ur connection here..
 
U need to have a 32 bit oracle client if ur DB is oracle.


Edited by Divi_2010 - 15 Mar 2011 at 5:13am
IP IP Logged
rob35244
Newbie
Newbie


Joined: 02 Feb 2011
Online Status: Offline
Posts: 3
Quote rob35244 Replybullet Posted: 15 Mar 2011 at 5:15am
We are 32 bit on the CMS server.  We have the 32 bit Oracle drivers installed on that machine. 
 
Our backend Oracle database is 64 bit on HPUX.
IP IP Logged
Divi_2010
Newbie
Newbie


Joined: 16 Feb 2011
Online Status: Offline
Posts: 7
Quote Divi_2010 Replybullet Posted: 15 Mar 2011 at 5:19am
did you follow the reply from Jeff?Try it. Thats how I did and it worked fine for me...I think u need to change your back end Oracle 64 bit to 32 bit odbc connection.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.