Import Pervasive DB files

Posted on 2006-06-02
Last Modified: 2012-08-13
I am trying to import some files into Crystal from a software package we use.  This software has a DB using Pervasive 9.  I had been able to link previously to the files but since the upgrade from Pervasive 8 to 9, I can only use MS access to import the files and run queries that way.  

The problem is that the data appears in Crystal until I try to run a query using date parameters.  Again, the only way I have found to get around this is import the file(s) into MS access and get it that way.

I have searched high and low on the net and also in Experts Exchange only to find a huge amount of info that does not appear to answer this specific problem...

Does anyone know of a solution to the apparent bug in Pervasive 9?

Can I import the file(s) to Crystal Reports v 10?

Any help is appreciated...  I never knew how much I use Crystal until I can't access my data...

Chris Emerson
<addresses deleted by mlmcc PE>

Question by:cemerson1
    LVL 100

    Accepted Solution

    According to this link CR 10 doesn't support Pervasive 9.

    According to this even CR XI doesn't support Pervasive 9.

    >>Can I import the file(s) to Crystal Reports v 10?
    As far as I know the answer is no.


    Author Comment

    The odd thing is that I have several table files and some files work and some do not.  I appears the only thing that hangs things up is when I put date parameter is to query a certain month...

    My hunch is that it's a bug within Pervasive but I cannot find anything on it...

    LVL 100

    Expert Comment

    Could be.  I don't know anything about Pervasive

    LVL 100

    Expert Comment

    Glad i could help


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now