[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 426
  • Last Modified:

Database Dll error when using .mdb file

When I run a crystal report from a client machine I get a Database Dll Error. This error only occurs when I reference an mdb file, otherwise the report runs perfectly. I've installed MDAC 2.8 on the machine to make sure I was up to date there. That didn't help and I was wondering if anyone knew what may be causing the problem or maybe make some suggestions. Only a CR 8.5 viewer is installed on the other machine, it's a 3rd part application that generates the reports. Thanks
0
TerraKeith
Asked:
TerraKeith
  • 4
  • 4
1 Solution
 
mlmccCommented:
There are several other Crystal dlls required for an application to use a database.  Were these installed with the apllication?

What version of Access are you trying to use?
What Jet driver are you using?  The latest Jet drivers are not included with MDAC after 2.5.

http://www.microsoft.com/downloads/results.aspx?productID=&freetext=jet&DisplayLang=en

mlmcc
0
 
TerraKeithAuthor Commented:
I'm using a 2003 .mdb file for storage and Jet 4.0. It says it can't find the database dll. I'm not actually deploying a utility or application, it's deployed in the reports folder of a 3rd part application which currently uses btrieve. It's a small add on with extra information taken from the .mdb file.
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
mlmccCommented:
You will need to get the Crystal MS Access database dlls and install them on the machine.  

Where did you get the report file?

Which verion and edition of Crystal?  Which version of Crystal does the 3rd party application use?

mlmcc
0
 
TerraKeithAuthor Commented:
The report file is just an update of a report that already exists for the 3rd party app. It runs without the ms access database included. I'm using crystal 8.5 for development and the viewer is 8.5 which is on the client machine and used by the 3rd party app.
0
 
TerraKeithAuthor Commented:
And the client machine doesn't have office, so I'm just pointing crystal to the .mdb file.
0
 
TerraKeithAuthor Commented:
I found out what was wrong, the pdbdao.dll was missing, just added that to the directory and it worked. Thanks for your help mlmcc
0
 
mlmccCommented:
Glad i could help

mlmcc
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now