when launch crystal viewer there is an error of "crdb_oracle.dll could not be loaded"

Hi,
    I get an interesting question. I developed a VB + CR9 Developer application on Windows XP and I deploy it to a new Windows XP. I installed Oracle client 9 on the new Windows XP and I am sure that the OCI is installed also. The Oracle bin is also added to PATH. I also distribute the following DLLs to new Windows XP in the path C:\program files\common files\crystal decisions\2.0\bin (and also have an entry in registry):
crviewer9.dll
craxdrt9.dll
u25dts.dll
ufmanager.dll
crdb_oracle.dll
crqe.dll
querybuilder.dll
    The whole deployment is done by using "Package and Deployment Wizard" comes with VS.
    Everything is configured properly and my VB application can launch the crystal report viewer to show reports.
    Now comes a problem. I do the same on a new windows 2000 and it fails to launch crystal report viewer! (error message is: The database DLL "crdb_oracle.dll" could not be loaded). I am sure that I followed all the steps on this new Windows 2000 (install Oracle client, OCI is installed, the CR DLL is copied and registered, make an entry in registry, add the oracle bin to PATH variable).
   Any idea?
LVL 1
ccworkAsked:
Who is Participating?
 
mlmccCommented:
That means a supporting dll was not included.

Required files for CR9
http://support.businessobjects.com/library/kbase/articles/C2012421.asp

mlmcc
0
 
frodomanCommented:
Make sure there aren't 2+ copies of OCI on the system: http://support.businessobjects.com/library/kbase/articles/c2015781.asp

frodoman
0
 
mlmccCommented:
Also ensure the adding of the Oracle path isn't clobbering the exisating path.  We just installed the Oracle 9i client and the Oracle path was put on the front in a way that precluded the use of the rest of the path.  

mlmcc
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
ccworkAuthor Commented:
Hi frodoman,
    I saw the article before. The windows 2000 is newly installed and only single copy of oci.dll is there.

Hi mlmcc,
     The Oracle bin path was put at the beginning of "PATH". How do I know if this preclude the rest of PATH?
0
 
mlmccCommented:
I don't recall but the fix was to append it to the path rather than put it on the front.

mlmcc
0
 
ccworkAuthor Commented:
Hi mlmcc,
     But on the Windows XP, teh Oracle bin path is also at beginning of PATH and there is no problem. I will try your suggestion.
0
 
mlmccCommented:
I was out of the office when this occurred here and was told that was how we fixed the problem  We are on Win 2K

mlmcc
0
 
ccworkAuthor Commented:
Hi mlmcc,
      I append the oracle bin path at the end rather than at beginning but the message <The database DLL "crdb_oracle.dll" could not be loaded> still appears.
0
 
ccworkAuthor Commented:
Hi,
    Here comes more information. On the new Windows XP, when I try to register crdb_oracle.dll at "C:\program files\common files\crystal decisions\2.0\bin", there is a message of: crdb_oracle.dll was loaded, but the DllRegisterServer entry point was not found. This file can not be registered.
    When I try to register crdb_oracle.dll on the windows 2000 at "C:\program files\common files\crystal decisions\2.0\bin", it says: LoadLibrary("crdb_oracle.dll") failed - The specified module could not be found.
0
 
ccworkAuthor Commented:
Hi mlmcc,
     Finally I install crystal report on the new Window 2000. Now there is no more crdb_oracle.dll error but I found that the report cannot fetch data from Oracle database!! That is, I start the crystal report 9 and open an existing report and then do a "refresh report data". All group section disappears, no data appears.
     Need help!
0
 
ccworkAuthor Commented:
Hi,
     Here comes with another information. I am using Oracle Client 9.2.0 and crystal report 9.2.2 on the windows XP and windows 2000 machine.
0
 
mlmccCommented:
Try changing the database driver

Open the report
Click DATABASE --> CHANGE DATABASE DRIVER
Click the check box
Change it to the correct driver (probably still your Oracle driver

See if you still have the problem

Try creating a new report

mlmcc
0
 
ccworkAuthor Commented:
Hi mlmcc,
     From the database menu of crystal report, there is no such thing of "change database driver". And interestingly, I create a simple report on the windows 2000 and it works. This sounds that the problem comes from the existing crystal reports. But it is painful to create everything again on the windows 2000. And the existing reports work well on windows XP ...
0
 
mlmccCommented:
Sorry bad memory - look for CONVERT DATABASE DRIVER

When we moved from the dev to prod environment even though we thought everything was the same and had worked before during the delay from testing to deployment they had upgraded many of the machines to Win2K from Win95 and hadn't installed the SQL clients so I had to do the same thing convert to the OLE driver.

mlmcc
0
 
ccworkAuthor Commented:
Hi mlmcc,
     Finally the problem is solved. The file "implode.dll" is missing. Yes, my existing reports are made from previous version of Crystal Report. The point goes to your account :)
0
 
mlmccCommented:
Glad i could help

mlmcc
0
 
mklietheCommented:
Solution Title: when launch crystal viewer there is an error of "crdb_oracle.dll could not be loaded"

I wanted to add a comment to this thread because I had a similar problem.  I am upgrading from Oracle 9i to Oracle 10g and installed the Oracle Client and other apps onto my Windows 2000 server.  This server holds Crystal 9 and the reporting function worked prior to the attempted upgrade.  After the Oracle Upgrade, I also received the crdb_oracle.dll error.  I followed all of the instructions above and nothing worked.  Then I finally determined that there was a service pack 2 for Crystal Reports 9 (http://support.businessobjects.com/fix/hot/si75/default.asp).  I downloaded and installed the service pack and it appears to have fixed the problem.

This information may be valuable to those that follow.  Thanks.

mark
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.