Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Pervasive and Accpac

Posted on 2011-10-28
Medium Priority
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 out...so 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
  • 4
  • 2
LVL 29

Expert Comment

by:Bill Bach
ID: 37045613
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

mirtheil earned 1000 total points
ID: 37045624
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

ID: 37045679
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
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

LVL 29

Assisted Solution

by:Bill Bach
Bill Bach earned 1000 total points
ID: 37045690
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

ID: 37045705
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

ID: 37056997
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

ID: 37069460
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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
Blockchain technology enhances society similar to the Internet. Its effects are broad, disruptive, and will boost global productivity.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

580 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