Pervasive and Accpac

Posted on 2011-10-28
Last Modified: 2012-05-12
Hi all Accpac/Pervasive experts,

I have an issue with one of clients which still runs  Accpac 5.2A and Pervasive 2000i database.  As you can all see the system is old but hardware is even older and is on its way it needs replacement very soon  

So we want to transfer Accpac 5.2A  to a newer system, in this case Windows 2008 SBS  64-bit version.  Due to the fact that he has only 2 Accpac users at any given time (LANPAK is 2 license) I have decided to install Accpac on the server and then run it via TS for these 2 users

Here is what I did so far

1.  Installed Accpac 5.2A  on Win 2008, applied the latest patches available for this version
2.  Installed Pervasive 11 64-bit   on Windows 2008 server
3. Create system and company databases
4.  Create System DNS entries, one pointing to sytem database and one to company database

     NOTICE 1:  I used Pervasive ODBC interface 64-bit version which was, I assume, installed by
                    installation process of Pervasive v 11
      NOTICE 2 :  I did NOT install Pervasive Client 32-bit edition which is available on the media,
                        hence I did not have the option to create a 32-bit DNS entry

   5.  Verify the macro and make sure that they don't crush when they run
   6. Dumped data from old system and upload in the new company database just created

Everything works OK, the system is fast but there's one problem.  There are missing records(data) which I noted when running the macro. Crystal Report in preview mode shows no data, just the page frame with no data.  However some other records are showing correct data.  

In my opinion (not an Accpac neither a Pervasive expert) it might be 2 things causing this problem

1.  I made a mistake during dump/upload process
2.  I have to install Client 32-bit from Pervasive CD, create 32-bit DNS for System and Company database and then use them instead of 64-bit

Thank you all for spending time reading my post and for any hint you might have


     Next steps

Question by:Bibecu
    LVL 28

    Expert Comment

    by:Bill Bach
    Pervasive PSQL v11 can read and write the same files that PSQL2000i can read and write.  Instead of step 6, you should have just been able to copy over the database files from the old server to the new one.  I don't know what process you used to dump & upload, but I would recommend just copying the files over & see if that fixes it.
    LVL 18

    Accepted Solution

    Can you create a new report and does that show the "missing" data?
    Is all of this running on one machine (the server)?  If so, even installing the 64 bit server engine will get you the 32 bit components.  You may need to create a 32 bit DSN and can do so either in the 32 bit ODBC Adminstrator (in c:\windows\syswo64\odbcad32.exe not c:\windows\system32\odbcad32.exe).  
    Does the PCC show the missing data?   If it does, then the problem is in the Crystal side of things.  If it doesn't then the dump/upload process might be at fault.  

    Author Comment

    Thanks Bill.  I think you refer to copy the files from \ACCPA\DATA\COMPANY\  directory  from old server onto the new one.  (DDF and DAT files)   I will try that and let you know

    I used Accpac built-in database dump and uplod process
    LVL 28

    Assisted Solution

    by:Bill Bach
    Exactly.  You should be able to directly copy the files from the old system to the new one, if it is the same version of Accpac.

    Author Comment

    Thanks Bill and Mirtheil for your prompt answers and suggestions, I will do it in the afternoon  ( I am EST zone) and let you know

    Author Comment

    In the new system I have created a new database/company  and then copied the DDF and DAT files over from the old system.  Tried to run the macros, same issue,  they work correctly for some records and do not work for others.

    To answer mirtheil's question, yes, everything is installed on the server so I got both 64 and 32-bit components.  I have tried with both, the issue remained

    At this point I think is a Crystal issue, I will investigate and let you know


    Author Closing Comment

    Thank you BillBach and Mirtheil for the solutions. The issue was actually a combination of ODBC and dump/upload

    I have divided the points because

    -BillBach provided the tip of copying the files instead of doing a DB dump/upload (something was wrong with the dump/upload process)

    -Mirtheil for tip of using ODBC 32-bit

    Thank you both for the time and effort


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
    CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    733 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

    24 Experts available now in Live!

    Get 1:1 Help Now