Crystal Reports Server 2011 - Error in File *.rpt: Failed to load database information.

Hi Experts,

I'm replacing an older CR Server with a new one and ran into an error when trying to run various reports.

CR Server: Windows 2008 64bit, Oracle 11g 64 bit and now 32 bit
Server where the database resides - Windows 2003, and Oracle 9i 32 bit

I installed CRS 2011 and installed Oracle 64 bit, and then uninstalled that version of Oracle with a 32 bit version.  

In Net Manager, I was able to create the entries for the tnsnames.ora file and was able to authenticate using the test with Net Manager.  When I run a report in CMC, I keep getting the error: Error in File ~tmp1fec78b204a83c0.rpt: Failed to load database information.

Any ideas on further troubleshooting steps?  I'm copying the install files of the Crystal Reports app itself as another troubleshooting step to see if that functionality is working.

Thanks!
byd2kAsked:
Who is Participating?
 
mlmccCommented:
How are you connecting to the database?

Not sure if CR 2011 supports 64-bit or not.

mlmcc
0
 
byd2kAuthor Commented:
I'm connecting to the database using Oracle.  I was thinking that the 64 bit version wasn't compatible so I installed 32 bit.  Is there a log or anything I can look at on the server to show more detail?

Thanks!
0
 
mlmccCommented:
Did you install the Oracle database dirvers?
 
You can look at the system logs.

mlmcc
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
byd2kAuthor Commented:
In regards to the Oracle driver, I did install Oracle 11g on the server.  Would these drivers be a separate install?  I looked in the ODBC settings and I did see an Oracle 11g 32 bit driver, however online I noticed some admins are stating to install the 64 bit driver as well.
0
 
mlmccCommented:
DO  you use ODBC to connect to the reports?

Did you build the ODBC connection?

mlmcc
0
 
byd2kAuthor Commented:
No.  From my last server configuration...  I installed CRS or just regular Crystal Reports and then the Oracle software.  Setup the tnsnames.ora and it worked from there.  Did I miss a step?
0
 
mlmccCommented:
We use ODBC connections so we have to set those up but if you are using a native driver that is available then that should work unless the install of Crystal doesn't install the Oracle native clients by default.

mlmcc
0
 
byd2kAuthor Commented:
Thanks for your help.  I rebuilt a new server and thanks to VMware, I was able to try each step until I ended up getting things right.  

So I:
Installed Windows 2008 64 bit server
Installed 32 bit version of Oracle - Ran tnsping, and made sure everything connected as expected
Installed Crystal Reports Writer - Thanks for other admins posting this tip.  Ran a report and ensured that data appeared
Installed 64 bit version of Oracle - Had to add the database name into NetManager for the 2nd time, and ran tnsping, etc
Installed CR Server

Of course I made the mistake of using a password with a punctuation mark in CR Server.  
Thanks again to VMware Snapshots!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.