Link to home
Start Free TrialLog in
Avatar of fuerteventura
fuerteventura

asked on

database DLL 'crdb_dao.dll' could not be loaded

I created a report in Crystal Reports 9 and coded a VB6 app to display it in the CR viewer. Everything was working fine until I packaged the application using the package and deployment wizard. I did a test install and now, when I try to call the report in VB6, I get the message "database DLL 'crdb_dao.dll' could not be loaded". What is causing this? The message appears when attempting to Access from running from VB6 itself and when running the installed app. It also de-registered one of my ct active x ocx objects. The crdb_dao.dll file is in the directory 'C:\program files\crystal decisions\2.0\bin' folder. Also, is it possible for the crystal report viewer to work within my app, even if a pc it is installed on doesn't have CR installed?
Avatar of Mike McCracken
Mike McCracken

>>Also, is it possible for the crystal report viewer to work within my app, even if a pc it is installed on doesn't have CR installed?
Yes.  You will have to create an installation package that has all the required dlls including the database dlls.

Did you try the install on your machine?

mlmcc
Avatar of fuerteventura

ASKER

Yes - I installed it on the machine that I'm developing it on - the one with Crystal Installed
Update - re-installing CR9 Pro edition solved the problem and it works again. However, I re-packaged my application and this time added the crdb_dao.dll file to the package. THis time when it installed, I got the message "database DLL 'querybuilder.dll' could not be loaded". This file is part of the installation package. Once again, re-installing CR9 solved the problem.  Bear in mind I only have the pro edition. Could this be the reason as I know the developer edition has the licence I require to distribute?
Yes, the pro edition doesn't have the license you need to be able to distribute.  By installing Crystal you are using that license on the machine.

mlmcc
Many thanks for your reply. I have just got around the proble by stripping out all of the reference to Crystal, with the exception of the 2 I need (which I now know are CRAXDR9.DLL  and CRViewer9.DLL). In addition to this I ensure that the installer places the other required DLLs (Which in this case are the crdb_***.dll and querybuilder.DLL) in the Program Files/Common Files/Crystal Decisions/2.0/Bin folder).
This allowed it to install fine after creating a package using the PDW. However, it only installs on the machine with CR9 on. On other machines, it falls over during the installation - specifically at the end when the installer states that it is updating the system. So one last question - would I be right to assume that the installation failing is due to that machine not having crystal installed and purchasing a developer version will solve the problem? Cheers again.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Many thanks for all your help & advice.